Home Forums Data Warehousing Integration Services SSIS Event Handling for Data Flow Tasks with Error Log in SQL Server Table RE: SSIS Event Handling for Data Flow Tasks with Error Log in SQL Server Table

  • Are you sure it works fine? You have a whole lot of blocking transformations in your package, which can lead to serious performance issues for large data sets.

    Anyway, on topic: every component in a data flow has an error path. (the red arrows) You need to configure the components to redirect rows when an error occurs.

    You can group the error paths with union all components and write the error rows to a database table.

    Regarding the user input: SSIS is not made for user input. It is an ETL tool and it is made to run unattended on a server.

    The only way you can have user input is to create dialogs in a script component, but that would mean the user has the execute the package manually using visual studio. Not really ideal.

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