I'm relatively new to DTS. I have used it successfully for a number of SQL data transforms.

I have created many DTS bulk export packages which exports all the SQL tables from a single database to external text files.

I can run these packages one at a time. I'd like to, however, run a batch process where I can run a bunch of these packages at once.

Can someone advise me on how this would be done - batch processing DTS packages?

Tim Barbour

You can use xp_cmdshell along with dtsrun and schedule the jobs

Here some more information

http://www.sqldts.com/default.aspx?215

Jaime E. Maccou
Applications Analyst