February 24, 2009 at 9:13 am
I think you'll need to get your typing hat on.
As far as I know there is no way to copy variables from one package to another. Each variable is referenced internally by a system ID which is created when you create the variable. There doesn't seem to be a way to copy and paste from one variables box in one package to another.
If you haven't created the other packages yet then you could create a copy of the package which contains the variables, remove everything in it you don't want then create several copies of this, renaming each one. This will save you having to manually create all the variables.
February 24, 2009 at 9:17 am
Thanks for the prompt response.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
February 24, 2009 at 9:42 am
Sorry - Is there a quick way to copy the package? If I save the project I then need to go through and change all the other filenames? Is this correct or am I missing a quick fix?
Thanks
Elliot
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
February 24, 2009 at 1:54 pm
Save first
right click the package, select copy
right click the SSIS Packages folder, select paste
Right click new package, select rename.. rename package (don't forget the .dtsx extension) and click yes when prompted about the object name
February 25, 2009 at 8:23 am
many thanks
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply