CODEWITHSUNDEEP
ssisadventureworks
Craigoh1
Craigoh1

Reputation: 167

Cannot map input column 'CurrencyDate', to lookup column, 'FullDateAlternateKey', because the data types do not match in AdventureWorksDW2008R2

I am attempting to learn SSIS by completing the Microsoft supplied AdventureWOrksDW sample database. I am up to step 6 - Adding and Configuring the Lookup Transformations. I can't seem to map the CurrencyDate to the FullDateALternateKey no matter what data type I change the CurrencyDate field to..

Has anyone been able to complete this and if so how? thanks

When I load Lesson1 I get the following errors..

Upvotes: 1

Views: 1712

Answers (3)

Neda
Neda

Reputation: 59

I faced the same problem when I had chosen "Microsoft OLE DB Provider for SQL server" as my connection manager provider, in this case "FullDateAlternateKey" was detected as [DT_WSTR] that wasn't correct. However, when I used "Microsoft OLE DB Driver for SQL Server", "FullDateAlternateKey" was detected as "[DT_DBDATE]" which was correct and it worked

Upvotes: 1

Avocado
Avocado

Reputation: 51

Added conversion and it worked, but recreated the flat file manager connection again.

enter image description here

Upvotes: 0

Tal
Tal

Reputation: 11

The FullDateAlternateKey in the DimDate SQL table has a type of [DT_WSTR] so I changed the type of the CurrencyDate to [DT_WSTR] instead of [DT_DBDATE] to match that type and I was able to map them fine.

Upvotes: 1

Related Questions