Post reply

configure OLE DB Destination Error Output

  • January 11, 2013 at 12:41 pm

    #149674

    I have an ssis Job (SSIS 2008) that loads data from a flat file to an SQL server 2008 table.

    I have a dataflow component where I do some transformations, and load to the database using an OLE DB Desination.

    on the destination, I configured the data access mode to: "table or view"

    however, when I open the error output, I can not configure an error on truncation. The field is grayed out.

    What am I missing, why can't I configure the error output

  • January 15, 2013 at 2:21 am

    #1577202

    In the OLE DB Destination, you won't get Truncation Errors (those are used in the pipeline of the dataflow). If there's a truncation error, it happens in the database engine and SSIS regards it as any other error. So you need to configure On Error.

    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