Link to home
Start Free TrialLog in
Avatar of Gowtham Ramamoorthy
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
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

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..
Avatar of Gowtham Ramamoorthy
Gowtham Ramamoorthy

ASKER

User generated image
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.
Your screen should look more like the one below and you can get to it by right-clicking on the source and selecting "Show Advanced Editor..."  Then check the Output columns since the External columns are determined by your query or source.

User generated image
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
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
btw you want to be looking at the source output columns not the error output columns