SSIS XML configuration files and multiple packages... -
04-11-2006
, 03:27 PM
Hi,
I migrate my DTS 2000 packages to SSIS.
and I want to use XML files for my configurations & parameters management.
I have 70 packages and 1 "master" package
The master package execute each child package in an optimized sequence.
I have to execute 10 times these packages for 10 projects (same databases
structure, but different database servers and 1 SSIS server)
for each execution I have to change the config files used to the specific
project I have to execute.
I have 1 folder by project:
c:\SSIS\Project1\Configs
c:\SSIS\Project2\Configs
....
I have 1 master config file which contains all my connections for a specific
project + 1 config file by package for package level configuration:
Connections.dtsconfig
packageXYZ.dtsconfig
in the master package I can't change the configurations file I want to use.
So how to tell my child package to use a specific config file?
can I create a "master configuration file"?
if I execute my master package with all the configuration files I want, does
these files are sent to the child packages?
there is any sample anywhere?
maybe I have missed something anywhere...
thanks for your help.
Jerome. |