Indirect configuration files in SSIS

Configuring packages based on configuration files is great, whats more you can have the location of configuration file obtain from an environment variable.

One word of warning is that, if you change your configuration between indirect and direct the configuration file will be overwritten and your conifguration settings lost.

What you need to do is delete the configuration based on the environment variable and then re add it but selecting your configuration file. This gives you the option to use the existing file and thus preserving your settings.

Jamie has mention indirect configuration files on his blog

Published Monday, February 13, 2006 8:55 AM by simonsabin
Filed under: ,


No Comments