SSIS Lookup transformations

[@ravindraravi7435]

Thank you ^^

[@BillionaireInvestmentCoach]

Great video I must say, well simplified

[@johnadoga9765]

"I'm getting this error cannot map the input column, because the data types do not match" in my visual studio write me a SQL query to change the datatype... Please Help

[@goshedy]

Yes you have to make sure the columns on the tables in the data base most have the same data types

[@goshedy]

Follow this link, it contain the instructions in the Video.
learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16

[@AdefilaOluwaseun-tu6qt]

I have watch this particular video twice now but still getting the error message cannot map the input column, because the data types do not match"

[@ankit6260]

I am also getting the same error. Can you please help me with this

[@santibravo8097]

Just change the provider. I got the same error, until I changed the provider. The problem was that I was using an outdated provider like 'SQLOLEDB.1', which has limitations when handling certain data types. Try with "Microsoft OLE DB Driver 19 for SQL Server" for the AdventureWorksDW2022 connection

[@jayantghorpade]

@@ankit6260 i'm also getting same error

[@jayantghorpade]

can your check your query plz
Select * from [dbo].[DimCurrency]
where [CurrencyAlternateKey] in
('ARS','AUD','BRL','CAD','CNY','DEM','EUR','FRF','GBP','JPY','MXN','SAR','USD','VEB')