June 4, 2009 at 11:51 am
Hi,
I want to create a configuration file (XML file) to be used by all my SSIS packages. When I create a SQL Agent job, I can specify the configuration file to use in the "configuration" tab.
If PackageA is calling PackageB and the execution of PackageA in scheduled in a job (with a configuration file), How I can tell PackageB to use the configuration file that PackageA received form the SQL Agent job?
Thanks
June 4, 2009 at 1:05 pm
Is it feasible in your environment to reconfigure package B so that its variables are parent package-configured from package A rather than as independent configuration file variables? This would eliminate the need for package B to know where A is getting its variables from.
June 4, 2009 at 2:16 pm
This seems to be a great idea.
Do you know where I can find information regarding this? Can you explain how to transfer variable from package to package.
I have a chain of 20-25 packages fired up at different moments. If I need to move everything to a test/dev environment, I need to open each packages and change manually the connections in the connection managers. What is is the best way to use the configuration file?
I am coming from a Sybase background and learning the MS-SSIS world.
Thanks for your help
June 4, 2009 at 2:35 pm
I've attached a brief description paper that I put together last November based on the way I build my parent/child packages. I hope that it's useful.
There is also a general article on parent and child package configurations on msdn at http://msdn.microsoft.com/en-us/library/ms345179.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply