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....

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 (AT) discussions (DOT) microsoft.com> wrote