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 - 2004-02-03 : 08:13:46
|
| lingam writes "I would like to create scheduled DTS package to import the data to one of the Databases of the SqlServer 2000. I am trying to create DTS package using "Import and Export Data" utility. When I try to schedule the execution using "Edit Recurring Job Schedule" wizard, the system is not saving the scheduled time that I mention rather it saves only the default time i.e. midnight. When change the time in "Daily Frequency - Occurs once at", the time is changed but once I click "OK" button and come out of the "Edit Recurring Job Schedule", it does NOT store the scheduled time but remains to be default time i.e. midnightHow to schedule the DTS Packag?" |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2004-02-09 : 15:52:45
|
| Why dont you create a job and call a stored procedure.In the stored procedure use dtsrun to call the dts package.You can schedule that job whenever you want. |
 |
|
|
|
|
|
Scheduled execution of DTS Package