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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to know if (x) DTS Package is running?

Status
Not open for further replies.
jpfo

jpfo

Programmer
Feb 11, 2002
6
0
0
PT
I have a little problem... In my program the clients must run DTS Packages, so in order to not install SQL components in the machines, i run it with a stored procedure (i call the master..xp_cmdshell). So far so good :)
Now have to run 2 DTS one after the other is completed.
Question: Is there any chance that i can make a routine in VB to know if a DTS is running (in order to know when i can execute the other)?
Tks in advance.

SQL7/VB6/WNT
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
135
Ken01
Ken01
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
626
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Word shows up even if Visible = False 1
Replies
2
Views
68
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
116
Andrzejek
Andrzejek
Michael OConnor
  • Locked
  • Question
Is this Meridian Mail
Replies
2
Views
64
Michael OConnor
Michael OConnor

Part and Inventory Search

Sponsor

Back
Top