Post reply

SSIS On-line tutorial practice question

  • January 3, 2009 at 9:43 am

    #126813

    Hi All,

    i am new to SSIS, i just started learning SSIS.In a tutorial example 1,when i am trying to map CurrencyID with CurrencyAlternateKey, a error occurs saying that datatypes of CurrencyID and CurrencyAltenate Key Do not match. I have changed the CUrrencyId datatype from string [DT_STR] to Unicode string [DT_WSTR] and data type of column CurrencyDate from date [DT_DATE] to database timestamp [DT_DBTIMESTAMP].Still the same error is occuring.

    Can someone help me pls

    Thanks For your Help

    Bobby

  • February 12, 2009 at 7:14 am

    #942827

    Not sure if you sorted this out. I had the same problem and noticed in a later version of BOL and other areas, you need to make sure you have locale for the data flow components to English(US). I have English(UK) by default so there's definite conflicts in the interpretation of the dates

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply