April 26, 2012 at 9:28 am
HI all ,
I am loading data from oracle to sql using SSIS package.
Below is the error message :
[OLE DB Source [1]] Error: There was an error with output column "EXCHANGE_RATE" (46) 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.".
[OLE DB Source [1]] Error: The "output column "EXCHANGE_RATE" (46)" failed because truncation occurred, and the truncation row disposition on "output column "EXCHANGE_RATE" (46)" 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 "OLE DB Source" (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.
the datatype for Exchange_rate is float in sql & it is same as in oracle.
I am not sure Why I am getting an error.
Please help me with this.
Thanks,
April 26, 2012 at 10:21 am
This is most likely do to precision differences between Oracle and SQL. Instead of the generic FLOAT type it is recommended you specify the scale and precision is both DBMS.
http://msdn.microsoft.com/en-us/library/ms151817%28v=sql.105%29.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply