March 8, 2014 at 10:27 pm
I am trying to simply extract data from sql server which supports DATE and dump it (without changes) into a SQL server which does not support DATE, but supports DATETIME. Now, my SSIS package uses only one data flow task with oledb source and destination. The source task executes SQL to fetch data. The source SQL task fails all the time with a a error given below. Can someone please help me to find out the reason and fix this ?
Thanks.
Error -
[GET MY DATA [1]] Error: There was an error with output column "A_DATE_COLUMN" (62) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
[GET MY DATA [1]] Error: The "output column "A_DATE_COLUMN" (62)" failed because truncation occurred, and the truncation row disposition on "output column "A_DATE_COLUMN" (62)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "GET MY DATA" (1) returned error code 0xC020902A. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
March 9, 2014 at 1:31 am
I'm not an expert here by any means but have you look at a data transformation task to explicitly convert the date to date time adn then use the converted column in the insert/update?
March 9, 2014 at 12:46 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply