Using SQL script as data source in SSIS
Posted on 2013-11-07
Inside my SSIS package, which is based on a sql script, I'm encountering the error below,
" [ADO NET Source ] Error: The component "ADO NET Source" (1) was unable to process the data. ORA-01840: input value not long enough for date format "
The data source is numeric, and I'm converting it to date within the script, the map-to field datatype in the data-destination is "datetime", and here's my date conversion formula within my sql script;
TO_CHAR(to_DATE(MYDATE,'YYYYMMDD'),'MM/DD/YYYY HH24:MI:SS')AS LastModDate