April 21, 2006 at 6:06 am
I have a number of "standard" Sser variables that I need to create in new packages. These variables are used to obtain information from the execution of the package which is loaded into tables. The question I have is...is there a way to create a script task to create these variables automatically? I would like to create this script so that I can add it to any new package and execute it to create the "standard" user variables in the package.
Any suggestions would be appreciated.
April 21, 2006 at 2:35 pm
Why not use templates for this? I think that some of the SSIS blogs discussed using templates. They should work in a manner similar to other VS project templates.
-Pete
April 24, 2006 at 4:40 am
Thanks for the suggestion. The problem is, we did some development and then had to go back and implement some tracking which required the creation of variables, the same ones, in over 30+ packages. I was just looking for an easy way to do this.
April 24, 2006 at 10:42 am
Well the files are all XML so it's possible that the variables are stored in a common place in all of the files. You could try to find them in a newly created package, then copy/paste that information in the appropriate place in the other packages - that may be faster if it's pretty standard.
-Pete
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply