Combine packages

• Alan Spillert

  SSCommitted

  Points: 1964

  More actions

  August 9, 2006 at 9:29 am

  #76563

  I have a dozen small, simple packages that copy data into tables and executed stored procedures to load them.  The Transform Data tasks are complex.  How can I combine these into one without redoing the Transforms?  

  Thank you for your help.

  We're using SQL-Server 2000 SP4 

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  August 9, 2006 at 11:29 am

  #654144

  Create a new DTS package and add Execute Package Tasks to execute each of your existing packages.