none
DTS_E_INDUCEDTRANSFORMFAILUREONERROR with Date conversion

    Question

  • Hi,

    My input file holds a date value which is in string[DT_STR] data Type.

    I need that date value to be displayed in the format 'MM/dd/yyyy' format.

    So i am using the SSIS expression in derived column transformation: 

    RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",31,(DT_DBDate)[Completion Date])),2) + "/" + RIGHT("0" + (DT_WSTR,2)DAY((DT_DBDate)[Completion Date]),2) + "/" + (DT_WSTR,4)YEAR((DT_DBDate)[Completion Date])

    But i got the following error,

    [New Records [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component "New Records" (1)" failed because error code 0xC0049067 occurred, and the error row disposition on "input column "Completion Date" (8895)" 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.

    How to solve this issue ?? please help !

    Thanks !


    --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

    Tuesday, December 11, 2012 1:27 PM

Answers

All replies