title: Cannot map input column 'CurrencyDate', to lookup column, 'FullDateAlternateKey', because the data types do not match in AdventureWorksDW2008R2
body: <p>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..</p>
  
  <p>Has anyone been able to complete this and if so how? thanks</p>
  
  <p><a href="https://i.stack.imgur.com/aoCHs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aoCHs.png" alt="When I load Lesson1 I get the following errors.."></a></p>