Search code examples
ssisvisual-studio-2019sql-server-data-tools

SSIS: Manage broken Data Flow Task because Excel column name changed?

I have a simple SSIS package that exports an Excel file to a csv file: each column in the Excel is mapped to a column in the csv.

Assuming that a column name in the Excel file changes, is it possible to gracefully manage this error so that it's marked as "failure" in the Precedence Constraint Editor and then moves on to the Failure task?

As it stands, if I run the package with a different column name, I'll get this error and everything stops: enter image description here

I'd like to edit it so that if the column changes, it goes to the "Send Failure Email" task. Is this possible?

enter image description here

Solution

  • I believe what you are looking for is this.

    This will then only validate when it reaches the task and not when the package initializes.

    enter image description here

    enter image description here