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 |
|
nrusa
Starting Member
4 Posts |
 Posted - 2008-02-21 : 16:02:56
|
| Hi,I created DTS package that exports data to text file. That work’s fine. For scheduling (SQL Agent Job) we don’t rights to do that. Is there any way to run the DTS package through BATCH file? Pls guide me how to do this task. ThanksNR |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 16:19:04
|
| You cal call the package with dtsrun. |
 |
|
|
nrusa
Starting Member
4 Posts |
Posted - 2008-02-26 : 16:12:55
|
| Could pls let me know little more details. My users wants to run DTS package from DeskTop. They are business users they don't have much knowledge on technology side.Thanks in AdvanceNR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 22:16:03
|
| But you are. Check books online to get details of dtsrun. |
|
|
|
|
|
|
Batch file for DTS Package?