Post reply

SSIS: ADO to IBM iSeries

  • February 28, 2012 at 12:06 am

    #265240

    Hi forum members,

    I have a ADO connection to iSeries.

    It works fine when I transfer all the data of one table into a SQL Server 2008R2 warehouse.

    When I want to reuse the same connection to transfer the data of another table, it doesn't work anymore.

    I'm fairly new to SSIS, so I'm probably about to ask a stupid question, but it is possible to reuse an existing connection, right?

    It's not that for every table that I want to transfer from one data source to another I have to make a different connection, even it's the same data source?

    Error:

    [INORLB [409]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "INORLB" (409)" failed because error code 0x80004003 occurred, and the error row disposition on "output column "RLSTAT" (505)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

    [INORLB [409]] Error: The component "INORLB" (409) was unable to process the data. Pipeline component has returned HRESULT error code 0xC0209029 from a method call.

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "INORLB" (409) 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. There may be error messages posted before this with more information about the failure.

    Any advise is appreciated.

    Thanks.

    Vera

  • February 29, 2012 at 3:31 am

    #1453027

    Are there any more errors?

    The first one says:

    may be error messages posted before this with more information about the failure.

    A connection manager creates a new connection everytime it is used.

    If you do not want this, you need to put the RetainSameConnection property to true.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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