In my Derived Column Transform editor I have the following
(DT_DBTIMESTAMP)(SUBSTRING(TRIM(Admit_Date),1,4) + "-" + SUBSTRING(TRIM(Admit_Date),6,2) + "-" + SUBSTRING(TRIM(Admit_Date),9,2) + " " + SUBSTRING(TRIM(Admit_Date),11,2) + ":" + SUBSTRING(TRIM(Admit_Date),14,2) + ":00")
The data type column has string [DT_STR] as the value.
The string looks like 2011-04-04 23:00
The connection manager has the datatype set to string [DT_STR) with the OutputColumnWidth set to 18
The Admit_Date field is in a temp table created like this [ADMIT_DATE] datetime NULL,
And below is the error I get
[Derived Column ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (203)" failed because error code 0xC0049064 occurred, and the error row disposition on "input column "Admit_Date" (251)" specifies failure
on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Any ideas. Everything I have read tells me to parse the string out like I have, and it works for all my date only fields. e.g. (DT_DBDAT
View Complete Post