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 ?

Gowtham RamamoorthyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
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.
Jim HornMicrosoft SQL Server Data DudeCommented:
^^^ and also please provide us screen shots of your lookup mapping plus data types..
Gowtham RamamoorthyAuthor Commented:
Sample screen shot
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Gowtham RamamoorthyAuthor Commented:
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.
Brian CroweDatabase AdministratorCommented:
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.

SSIS Advanced Editor
Gowtham RamamoorthyAuthor Commented:
Thanks.. I got this one.. here i can see the data type as 'STRING' ... what can I do to match the destination in the varchar...
Gowtham RamamoorthyAuthor Commented:
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 ?
Brian CroweDatabase AdministratorCommented:
Make sure the type and length match between the external and the output columns.  If they can't be implicitly cast or if the length is shorter on the output column you will get an error by default.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian CroweDatabase AdministratorCommented:
btw you want to be looking at the source output columns not the error output columns
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.