February 16, 2011 at 7:14 pm
I hate source field date like this :- 08312011
04302008
07132005
08312004
08312007
08312001
08312007
08312007
08312007
I am using this expression in derived column:-
(DT_DATE)(SUBSTRING([Copy of Entry Date],1,4) + "-" + SUBSTRING([Copy of Entry Date],5,2) + "-" + SUBSTRING([Copy of Entry Date],7,2))
And I am receiving error. Error is listed below
“[Derived Column [149]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (149)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "START_DATE_1" (937)" 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.”
Please guide me where I am wrong.
February 17, 2011 at 1:37 am
Looks to me like your derived column expression would work for dates formatted as YYYYMMDD, whereas your dates are in MMDDYYYY format - so you just need to change the start positions/lengths in the SUBSTRING functions accordingly.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply