SSIS Error

• naveen.bethi

  Grasshopper

  Points: 16

  More actions

  January 5, 2009 at 1:01 pm

  #129726

  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

  Bethi

• Dave Wolstenholme

  Mr or Mrs. 500

  Points: 575

  More actions

  January 5, 2009 at 1:13 pm

  #921391

  Bethi,

  Are you doing this in a data conversion task? If so, did you re-map your fields in your destination object?