posted on Monday, January 24, 2005 3:09 PM
by
Knight_Reign
Package Configurations II
In an earlier blog I wrote a little about package configurations. IDW11 (December CTP) had limited support for SQL Configurations. That will be changing in the next CTP build (IDW13), slated for sometime in Feb. You will no longer need to script a table for the configurations. Support will be built into the Package Configuration wizard. It looks something like this:
You'll still need to insert the configuration values as described in the earlier blog post, but the wizard enhancement should make it much easier to set these up.
Someone also asked how the configuration name is used. It's placed in a ConfigurationFilter column in the SQL Configuration Table. Essentially, the SQL Configuration uses this to query the table and extract a subset of configurations. Using this field you can create multiple configurations for the same package or set of packages. Or, use it to simply group configurations for a particular solution etc.
Look for this change in the IDW13 build and let us know what you think.
Thanks,
Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden