SSIS - Flat file to OLEDB Destination
I have the flat file with the data
which i need to import the data into the column with the datatype - datetime into sql 2005 table. I tried all possiblility in changing the datatype which matches the destination. In the OLEDB Destination the datatype for the column is "database timestamp [DT_DBTIMESTAMP]". I tried the same by changing the DT_STR to DT_DBTIMESTAMP in the Flat file source through Show Advanced Editor page, nothing working as expectation.
Your suggestion is highly appreciated.