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.