MS SQL Server - DTS Package Copy

Author

DTS Package Copy

Jim Heavey

2006-03-30, 8:23 pm

I want to copy the contents of one package into another package. I can bring
up the 2 packages side by side 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....

John Bell

2006-03-31, 3:23 am

Hi Jim

I am not a DTS expert, you may want to try the DTS newsgroup
microsoft.public.sqlserver.dts. I assume that you can not just call the
second package from the first.

John

"Jim Heavey" wrote:

> I want to copy the contents of one package into another package. I can bring
> up the 2 packages side by side 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