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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-06-02 : 09:45:24
|
| I've got 7 DTS scheduled jobs which will send an email with 5 EXCEL spreadsheets attached.(OK Damian, maybe Reporting Services would have been better.)I'd like to reduce the 7 jobs to a single job with 7 steps, but I'm stopped by the following...Using EM's "export" feature, I can run a stored proc and save the result to an EXCEL file on the server's hard drive. This step can be saved as a DTS package. I've done this 5 times for 5 different reports.Now, the only way I can find to schedule these saved DTS packages is to schedule each independently of the other. 5 jobs. Plus one to delete files and other to email.Is there any way to create a JOB step and specify a DTS package that should be executed? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 09:47:44
|
quote:
(OK Damian, maybe Reporting Services would have been better)
 quote:
Is there any way to create a JOB step and specify a DTS package that should be executed?
Yep, call the dtsrun.exe app to run a DTS package.DamianIta erat quando hic adveni. |
 |
|
|
|
|
|
Better way to do this