Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssis_newbee
Starting Member
8 Posts |
 Posted - 2011-08-10 : 07:55:28
|
| HI , my SSIS Package, has a data flow which fetches data from SQL , where data access mode is from SQL Command from Variable. After this i have a look up , where OLEDB Source data is been looked up with Access 2007 source data. All works fine but look up does not handle case sensitivity , where my complete data does not pass in look up. My source sample data (OLEDB) ID Name 1 ABC 2 CDE 3 fgh Access Data ID Name Address 1 ABC hyd 2 CDE mumb 3 fgh Chennai so i have used a Query in Access to Convert Name to upper case SELECT ID, Ucase(Name) as Name, Address FROM User and tried look up with Name column where i received the error Cannot map the lookup column (Name), because the column data type is a binary large object block (BLOB). I tried to convert Name column to string by using the query have used a Query in Access to Convert Name to upper case SELECT ID, Cstr(Ucase(Name)) as Name, Address FROM User Still i receive the same error. I planned to use Fuzzy look up instead, but i see that Fuzzy look up can peform a look up only to a SQL Table which will not work in my case. Please let me know your inputs in solving this scenario. Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-10 : 08:01:36
|
| try to cast the field to varchar(max) and then use it. alternatively you can try casting it inside ssis derived column also------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ssis_newbee
Starting Member
8 Posts |
Posted - 2011-08-10 : 08:08:23
|
| Hi Vishak,Thanks very much for the reply.I have Access source as my look up data, i dont have varchar(max) data type in access.for this Access data in look up, we cant use derived column transofrmation right |
|
|
|
|
|
|
|
|
Cannot map the lookup column Error