posted 1/28/2011 by timmurphy - Views: [1664]
In SSIS you might have occasion like I did to do a Lookup that needs to match data of different types. Here is the error you may get when you try to map the lookup column.
There are a couple of ways you can fix this. One possibility is to convert the data by using the Data Conversion Transformation.
The other way is to use CAST in your SQL query for the Lookup (assuming you are using the Best Practice of a SQL query).
I used the first method and never thought but the second one. Thanks its helpful for me