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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2007-03-19 : 15:36:31
|
| i have a DTS Package a saved when i set up the package. it's in local packages in Enterprise Manager now. is there any way i can simply set up a shortcut on my desktop to execute that DTS, rather then having to nav though Enterprise Manager?yeah, i know i'm lazy :o) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-19 : 15:46:45
|
| You can execute DTS packages from command line via dtsrun.exe, which you can wrap into a bat/cmd file and save to your desktop. dtsrun.exe is documented in SQL Server Books Online.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2007-03-19 : 16:04:22
|
| Perfect, that will be all i need. thank you! |
|
|
|
|
|
|
Point and click DTS