sql server - SSIS Issue with date conversion -
i'm working on importing csv db. data should work, it's data application used through dblink have csv upgrade. dates this: 4/30/2001 tried simple import numbers , strings, , got error, did derived column. derived column works on dates not null (formula (dt_date)dte) derived column failed on dates can contain nulls. tried update formula (isnull(edte) ? null(dt_date) : (dt_date)edte) . no success, still error: [flat file source - o1 [6743]] error: data conversion failed. data conversion column "edte" returned status value 2 , status text "the value not converted because of potential loss of data.". originally, in flat file source, dates set type date, , got error before got derived column. i've changed string, , makes derived column, both boxes red. here's error: [derived column 1 [17270]] error: ssis error code dts_e_inducedtransformfailureonerror. "component "derived column 1" (17270)" failed because error code