ilokris | SQLServerCentral

ilokris

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

I use the EXp and I got this Error msg.
“[Derived Column [2]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Derived Column" failed because error code 0xC0049063 occurred, and the error...

February 19, 2015 at 11:38 am

#1778734
RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

@luis,
Your Question: ''Why don't you define your column as a date data type in your flat file connection and save yourself some problems? Your destination column should be...

February 19, 2015 at 9:39 am

#1778685
RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

I am still getting error. the column name from flat file is "[cln enc date]" FYI.
Please could you include that in the code? if possible also include "NULL" handling...

February 19, 2015 at 9:27 am

#1778681
RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

The Data type is VARCHAR(50)
Thanks

February 19, 2015 at 8:48 am

#1778666

Viewing 4 posts - 1 through 4 (of 4 total)