p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   SQL Server DTS (http://p2p.wrox.com/sql-server-dts-108/)
-   -   DTS text file export - Batch Process (http://p2p.wrox.com/sql-server-dts/21629-dts-text-file-export-batch-process.html)

Tim Barbour November 23rd, 2004 10: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 10: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 12:55 AM.

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