Hi, I want to do a lookup on a column with DT_R8 data type, but actually contains integer values. Is there a possibility of using a cast and doing this in a lookup in SSIS 2005. Any help would be greatly appreciated. Thanks in advance,

I can give a start point for this .There is an option for SQL Query in the Lookup transformation by which an sql query can be built up to cast to the required data type and a look up can be performed. Please check below: Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

--CAST (ANSI standard) SELECT CAST(someColumn AS INT) AS someColumn FROM someTable See also: http://microsoft-ssis.blogspot.com/2011/01/cast-and-convert-to-avoid-data.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com