 | |
scheduling problems
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
scheduling problems -
04-21-2005
, 08:42 AM
#2
| |||
| |||
|
|
Any help is appreciated.... I am having difficulty scheduling a DTS package to run. If I simply "execute" the DTS manually, everything works exactly the way it is supposed to. However, when scheduled, the process fails. And when it fails, the table is emptied of all records. The actual DTS package is setup to: 1. Connect to an Excel Table 2. Drop existing table in the DB 3. Create new table in the DB 4. Populate new table with recs from Excel Table Any insight is appreciated, or if you need more detailed info about the DTS I will do so. I just need a bit of help here! Thank You! j |
#3
| |||
| |||
|
|
This KB should answer your questions about running DTS as a scheduled job: http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a Scheduled Job Check out www.sqldts.com as well. -- Andrew J. Kelly SQL MVP "jamesfreddyc" <jamesfreddyc (AT) discussions (DOT) microsoft.com> wrote in message news:5BB0F8C3-0793-40E8-BB62-AC04F0FE4021 (AT) microsoft (DOT) com... Any help is appreciated.... I am having difficulty scheduling a DTS package to run. If I simply "execute" the DTS manually, everything works exactly the way it is supposed to. However, when scheduled, the process fails. And when it fails, the table is emptied of all records. The actual DTS package is setup to: 1. Connect to an Excel Table 2. Drop existing table in the DB 3. Create new table in the DB 4. Populate new table with recs from Excel Table Any insight is appreciated, or if you need more detailed info about the DTS I will do so. I just need a bit of help here! Thank You! j |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.