Hi, I hope someone might be able to help me. I'm stepping through the "Creating a Simple ETL Package" tutorial and I've run into an error I can't seem to resolve.. Step 6: Adding and Configuring the Lookup Transformations 8. On the Columns page, make the following selections: a. In the Available Input Columns panel, drag CurrencyDate to the Available Lookup Columns panel and drop it on FullDateAlternateKey. ERROR "Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. With AdventureWorksDW2008R2, the table DimTime no longer exists, so I've determined DimDate as being the lookup table. The Sample Flat File Source Data has CurrencyDate set to [DT_DBTIMESTAMP] as per the tutorial, however the DimDate.FullDateAlternateKey datatype is set as DATE. I've tried changing CurrencyDate to match but this isn't working and I'm now a bit lost as to how to proceed. I'm in the UK so the date format is obviously different (DD/MM/YYYY) so I'm thinking I might need to do some kind of conversion but not sure how/where. Thanks for your time. Tutorial here: http://msdn.microsoft.com/en-us/library/ms169917.aspx

Thank you very much for your response, Nitesh! Unfortunately the source data is coming from a flat file (tutorial file: SampleCurrencyData.txt). The tutorial states that the column datatype in the Flat File Connection Manager Editor should be set to database timestamp [DT_DBTIMESTAMP] - I can change this to string [DT_STR] but this still won't match with the lookup even if I use a query and convert the source column in the Lookup Transformation Editor.

Okay I has a stupid. I've been trying to work get the package set up on AdventureWorksDW2008R2 and it's just not going to work out due to schema changes so I'm installing AdventureWorksDW and should be able to get it working on that db. Thanks again Nitesh for taking the time to respond.

How unfortunate that after over a year later, Microsoft still has not updated the SQL2008 R2 SSIS tutorial instructions to reflect the actual data layouts of their provided SQL 2008 R2 tutorial scripts/files/databases (the AdventureWorksDW database schemas apparently were modified between SQL2008 and SQL2008R2). It would probably be safe to say that there is no intention to do so after all of this time, as SQL2012 is now available.

Since FullDateAlternateKey data type is date in AdventureWorksDW2008R2, I used [DT_DBDATE] for CurrencyDate column in step 2, and it worked.