Home > Archive > MS SQL Server DTS > April 2006 > Copying Packages









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Copying Packages
Jim Heavey

2006-03-31, 7:34 am

I want to copy the contents of one package into another package. I can bring
up the 2 packages side by side in DTS Designer and I can copy things like
the Connection and the Text file, but I can't copy the transform between the
2 opjects....Is there a way to copy the contents of one package into another?
Is there a way to copy the transform object between to packages in the DTS
designer?

Thanks in advance for your assistance....

Bill Swartz

2006-04-02, 3:27 am

Jim, unfortunately there isn't a way from the designer. You can create
package and copy the entire package,(by saving as), but you can't copy
individual transformations.

What you might want to do is create a package that just has the
transformations you want to re-use, then call that package from within the
other 2 packages.

Bill

"Jim Heavey" < JimHeavey@discussion
s.microsoft.com> wrote in message
news:FE211FE8-8093-40F9-A2D2- 8AD67B38D447@microso
ft.com...
>I want to copy the contents of one package into another package. I can
>bring
> up the 2 packages side by side in DTS Designer and I can copy things like
> the Connection and the Text file, but I can't copy the transform between
> the
> 2 opjects....Is there a way to copy the contents of one package into
> another?
> Is there a way to copy the transform object between to packages in the DTS
> designer?
>
> Thanks in advance for your assistance....
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com