I am using package configurations to set SSIS package variables from the SQL server Database [SSIS Configurations] table. I have an environment variable set as my first configuration, to hold my database connection, and then the subsequent configurations
are SQL configuration entries and held in the [SSIS Configurations] table.
When testing in BIDs, the connection is OK and the designer shows the correct values have been picked up. All good!
But, when we change the database value in the [SSIS Configurations] table, the old configuration is still being used in BIDs.
I have checked using Profiler that BIDS is calling and retrieving the correct value from the table but the modified value is not being used in BIDs, instead it is retaining the old value when the package was designed.
How do I force the SSIS package to use the configuration specified in the SQL table?
View Complete Post