I am writing a query where I need to use the following calculated column months_between(add_months(STARTDATE, PERIOD), STARTDATE) as months_left When I execute the query in the oracle it works fine and give expected (Integer) output but when I try to execute the OLE DB data source without this column, it gives the following error messages [OLE DB Source [1190]] Error: There was an error with output column "MONTHS_LEFT" (1305) on output "OLE DB Source Output" (1200). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". [OLE DB Source [1190]] Error: The "output column "MONTHS_LEFT" (1305)" failed because truncation occurred, and the truncation row disposition on "output column "MONTHS_LEFT" (1305)" 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" (1190) 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. My defult code page for OLE DB Source is 1252, AlwaysUseDefaultCodePage = True, Local ID = English (United Kingdom) I am unable to understand what I need to do about this but I have given a try to put 'to_number' to convert the result in number but still the result is same. Without this column query works fine Please advise DigitalFM

You get a truncation error. This means that the data you selected for a certain column doesn't fit in the space allocated for that column in the SSIS memory buffer. Open the advanced editor for the OLE DB Source and go to the output columns. Check the length of the MONTHS_LEFT column (is it a string?) and change it if is too small.MCTS, MCITP - Please mark posts as answered where appropriate.

Agree with koen data truncation happening please increase output of MONTHS_LEFT column lenth

Hi Keon It is number, I have changed the data type form string to number and with corect lenth and now it is through but i am still thinking why it has took string data type to a number field. Thanks for the handy helpDigitalFM

I have changed the data type form string to number and with corect lenth and now it is through but i am still thinking why it has took string data type to a number field. That is indeed strange. Maybe SSIS had troubles mapping the Oracle datatypes.MCTS, MCITP - Please mark posts as answered where appropriate.