dbTalk Databases Forums  

SSIS XML configuration files and multiple packages...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS XML configuration files and multiple packages... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.