Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to combine 2 large DTS Packages?

Author  Topic 

danyeung
Posting Yak Master

102 Posts

Posted - 2007-09-06 : 13:06:47
I want to combine two large DTS Packages. I tried to select all in Package2 and copy all. I got a DTS Package Error "Select only one item." How can I combine them without copying one item at a time? There are over 100 items.

We decided not to create Package3 to execute Package1 and then Package2 because there are issues about reporting failure. I need help on combining two.

Thanks.
DanYeung

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-09-07 : 08:04:19
Sounds like you'll be doing a lot of work to create a maintentance headache! What are the issues about reporting failure? I'd be inclined to try and address these and keep the solution modular.

Mark
Go to Top of Page
   

- Advertisement -