Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 5th, 2006, 11:23 AM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default HELP!!!!! Sequential DTS

I need the help from anybody who knows how to create a sequential DTS, because I need to make a DTS that runs every half hour for different organizations but sometimes the DTS of the second organization starts before the DTS of the first organization ends and that makes that the data from one organization ends in the file of the other organization so if anybody knows how to program the DTS to pause until the last one ends please let me know.

Thanks,
Edgardo Cabrera.
 
Old October 11th, 2006, 11:54 AM
Authorized User
 
Join Date: Jun 2004
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If each organisation has a seperate DTS package you could have one master DTS package that executes each of the other DTS packages on completion of the last?

Use the 'Execute package task'

Don't know if there is a better way of doing it?

Stu





Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential File Manipulation chandan8888 BOOK: Professional Visual Studio 2008 ISBN: 978-0-470-22988-0 1 January 14th, 2013 05:02 PM
sequential transformations alexan XSLT 0 July 24th, 2008 11:59 PM
Sequential numbering help gear1 Access 1 April 9th, 2007 06:31 AM
Sequential Numbers ricespn Access 5 February 17th, 2007 02:54 AM
Sequential Numbers ricespn SQL Server 2000 14 November 1st, 2006 12:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.