single SSIS package with multiple package configurations

1
votes

I have an SSIS package with 2 package configurations (Configuration1 and Configuration2) with configuration locations stored in 2 different enviornment variables. Which configuration has to be used is decided based on the value of a variable (@type) passed at run time.

That is , use Configuration1 when @type ='override' and use Configuration2 when @type ='overload'.

How can I do this in SSIS?

1
configurationssis

1 Answers

0
votes

You can use an SQL Execute Task which is executed optionally (based on the value of @type using Expression in Precedence Constraint) to update the value of Configuration in the "SSIS Configuration" table. You should in this case migrate your configuration from "Environment Variables" to SQL Server table.