April 6, 2009 at 11:26 pm
Dear Pals,
I have a requirement where i need to pass the variables defined in one package to the second package of the same project, where the first package is created.
This is something like having Project-Level ( in similar to Package-Level) variables ,where all the DTSX pkgs created in that package make use of that variables.
If variables of such scope do not exist in SSIS 2005, please suggest any work around to my requirement.
Thanks,
[font="Comic Sans MS"]Vampire.[/font]
--In 'thoughts'...
Lonely Rogue
April 7, 2009 at 8:46 am
To my knowledge there are 2 ways to do this.
1. Use a configuration file to store the variable values and use the same configuration file for each package.
2. Create a Master Package that includes the sub packages and define the variables there and use the package configuration to set pass the value through to the child packages.
Check out this article
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 8, 2009 at 3:50 am
Thanks Jack,
I have read the referenced article in MSDN and successfully configured to pass the Parent pkg variables to the Child pkg.
The straight link is : http://msdn.microsoft.com/en-us/library/ms345179(SQL.90).aspx
Thanks,
[font="Comic Sans MS"]Vampire[/font]
--In 'thoughts'...
Lonely Rogue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply