Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-01 : 08:37:42
|
| Joao writes "I had the need for implement in my clients the option to run some DTS. In order to do that i've used a stored procedure using the "exec master..xp_cmdshell" because i didn't want to install the SQL components in my client machines ( i'am using VB6 ).My problem is that after the DTS is completed ( and it takes some time... ) i must execute some routines in my program, so would be nice to now when it's completed... Is there any way to know when a DTS is running ( or stopped )?I'am using SQL server 7 in a WNT, and for programming i'am using VB6.Tks in advanceJP" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-01 : 09:08:44
|
| You can try using the dtsrun utility with the /W or /L flags, these control the Windows Event log and DTS log files, respectively. I'm not sure if you'll be able to check these from a client machine, however.One really easy way to do this is to add a step to the very end of your package, that inserts a row into a "status" table, including the date/time the package was run. Then you can write a query to check for any rows with today's date/time and go from there. |
 |
|
|
|
|
|
How to know if a DTS is running?