p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server DTS (http://p2p.wrox.com/forumdisplay.php?f=108)
-   -   DTS text file export - Batch Process (http://p2p.wrox.com/showthread.php?t=21629)

Tim Barbour November 23rd, 2004 11:36 AM

DTS text file export - Batch Process
 
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

jemacc November 23rd, 2004 11:50 AM

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


All times are GMT -4. The time now is 05:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.