Date conversion Error in SSIS package

• mcfarlandparkway

  SSCertifiable

  Points: 7701

  More actions

  February 16, 2017 at 10:05 am

  #327296

  I have Data flow task where from source I have a date column called datatype date

  IN the destination table I have same column called datatype date.

  But when I ran SSIS package

   Description: Theexternal columns for OLE-DST - are outof synchronization with the data source columns. The external column"Dt" needs to be updated.

  Any ideas i tried to change by going into Advanced editor and selected external columns and choose this date as DT_DBDATE but still its converting into Unicode string. not sure where I am doing mistake.

• contact_arc

  Mr or Mrs. 500

  Points: 582

  More actions

  February 18, 2017 at 7:11 am

  #1929240

  Could not reproduce this issue. Try recreating the task.