error row disposition on "output column in SSIS

  • I am importing Data from a SAP table to a SQL Table.

    Just a straight loading into SQL Table no Transformations used in this.

    I got this Error::

    [SAP with Biztalk adapter [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "SAP with Biztalk adapter" (1)" failed because error code 0x80131537 occurred, and the error row disposition on "output column "XXXXX" (897)" 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.

    I am selecting the SAP data using a query.

    I have this problem with only one Column; If I remove the column from that query everything working fine.

    Can anybody help me with this Error. Is this Error related to the Data or is any thing related to package creation ??

    Thanks in advance

  • I'm having a similar issue...can anyone please advise?

  • An important part of the error message: "There may be error messages posted before this with more information about the failure."

    Generally, I've found that to be the case - so please post the entire text of the errors which you are getting.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Maybe this will help:

    ____________
    Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.

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

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