Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I execute multiple DTS packages as a single, scheduled job?

Status
Not open for further replies.
prevost999

prevost999

Programmer
Jun 28, 2001
38
US
I have created multiple DTS packages and would like to know how I can execute them all as one scheduled job.
 
Sort by date Sort by votes
Create a SQL Server Agent job; this lets you run a group of DTS jobs at one scheduled time, and even lets you skip some jobs based on the outcome of other jobs. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
890
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
912
BobSuruncle
BobSuruncle
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
600
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
616
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top