SSIS - DataReader Source gives a error after pulling in 41565 records

  • I get the following errors after pulling in 41565 records from a Intersystems Database with the DataReader Source:

    [IPSTAT_TRANSFER_FROM [1]] Error: The component "IPSTAT_TRANSFER_FROM" (1) was unable to process the data.

    [DTS.Pipeline] Error: The PrimeOutput method on component "IPSTAT_TRANSFER_FROM" (1) returned error code 0xC02090F5. 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.

    [DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.

    [DTS.Pipeline] Error: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

    [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0047039.

    Can someone please help me

  • You have not speciifed that you were loading data from another database or some files.

    This error comes once you have EOF mark or End Of Line mark before or some special character

  • Hi thanks for the reply. i am loading data from a Intersystems database called Cache' into MSSQL. I have wrote other SSIS package which is more or less the same as this and now I am getting this error

  • The error is coming from the driver being used to connect to your Intersystems database. I am not familiar with Intersystems, but if you are using some kind of ODBC or .Net driver for accessing the database, the problem is there. I may be that it cannot handle some characters in your data, or just be a bug or memory problem in the driver.

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

You must be logged in to reply to this topic. Login to reply