HI, Im SSIS i am using a lookup transformation, which is giving an error , about which i have no idea. In lookup transformation in Column mapping, I am mapping 2 columns both having same datatype (Int), still the lookup transformation gives an error "Cannot map the input columns C1 to the lookup column S1 because the data types do not match". Does anyone have an idea about this ??

both exactly the same int? (dt_i1, dt_i2, dt_i4, dt_8)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

In SSIS INt is more different as in SQL. You have to cast one of the columns to the right Type. Place a dataviewer behind the Lookup Task and verify the datatype.

Hi, i placed dataviewers & checked the datatypes, they are exactly same For query in lookup in the lookup :- "Name" "Data Type" "SourceID" "DT_I2" From source (Input to lookup ):- "Name" "Data Type" "SourceID" "DT_I2" I am mapping SourceID of source to SourceID of lookup table, & still getting the error. Even in the query, i used cast(SourceID as int) still, both columns are not mapped.

Using that CAST is definitely going to cause problems. A SQL Server INT is equivalent to a DT_I4 in SSIS. Talk to me now on