I am getting below error when I am adding row into destination table using derived column.
[Add PaymentDate_FirstOfMonth from variable ] Error: An error occurred while attempting to perform a type cast.
[Add PaymentDate_FirstOfMonth from variable ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Add PaymentDate_FirstOfMonth from variable" failed because error code 0xC0049064 occurred, and the error row disposition on "Add PaymentDate_FirstOfMonth from variable.Outputs[Derived Column Output].Columns[Derived Column 4]" 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.
[Charges Transaction Source ] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
---> And below is my derived column expression which comes from variable( variable data type is string) and destination column datatype is date.
aymentDate],1,4) + " - " + SUBSTRING(@[User:
aymentDate],5,2) + " - " + SUBSTRING(@[User:
Can you please help me any one where I am wrong on this expression.
I appreciate your help.