Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
DTS_E_INDUCEDTRANSFORMFAILUREONERROR with Date conversion

Answered DTS_E_INDUCEDTRANSFORMFAILUREONERROR with Date conversion

  • Tuesday, December 11, 2012 1:27 PM
     
     
    Sign In to Vote
    0

    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 | --------------------------

     

All Replies