Gowtham Ramamoorthy
asked on
Cannot Map the input Column,because the datatype doesnt match
Hi ,
When I tried to match the lookup columns inside the lookup shape I get the mentioned error in SSIS 2013 version.
I checked and corrected the data types in the source and the destination but till the error occurs. How can I match the columns for this case.
Can someone help ?
Regards
Gowtham
When I tried to match the lookup columns inside the lookup shape I get the mentioned error in SSIS 2013 version.
I checked and corrected the data types in the source and the destination but till the error occurs. How can I match the columns for this case.
Can someone help ?
Regards
Gowtham
Check the types of the input and output columns for the source data. right-click on the source task and select the advanced editor and input/output columns tab. I don't have SSIS in front of me so I don't remember the exact labels.
^^^ and also please provide us screen shots of your lookup mapping plus data types..
ASKER
How can I match the columns in this case.... I checked everything seems to be fine and same datatype.. Even I wrote a query to get converted to the varchar values from source and destination.. still the error occurs.
ASKER
Here the column is showing the string type.. Do I need to change the lookup to someother datatype ? or the data type of the source to some other form here in the advanced editor.. can you please guide me ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
btw you want to be looking at the source output columns not the error output columns