Using the same XML configuration file for configuring connection string of multiple packages in SSIS
-
Hi,
Is it possible to configure connection string of multiple packages of same solution file in SSIS 2008 to the same XML configuration file? I performed a Package configuration for connection string on one package and it worked, but when i tried to use the same XML config file to configure the connection string of the other packages,the file was overwritten even after selecting the option "reuse existing " file at the prompt.
how do i overcome this issue ?
Thanks in advance 🙂
-
The way the SSIS handles package configurations is not very useful. Whenever you use the configuration wizard, it will always overwrite the existing file and you will loose all your painstakingly prepared configuration. There is only one available solution. You have to extend and maintain the configuration file outside in your favorite XML editor. If you want to reuse the configuration file in multiple packages, you have to:
1. Create a copy of your master configuration file.
2. Setup your package to use the master configuration file. The configuration file will be overwritten.
3. Save the package and close it.
4. Remove the just created configuration and restore your master configuration file.
Now you will have your package setup to use this master configuration file.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply