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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2004-04-29 : 09:13:49
|
| Hi,I have a dts package that is scheduled to run as a job. It pulls data from a datasource connected through ODBC into Sql server database.The data is pulled into a table in the sql server database. The job runs fine for some days (3-4 days) with no issues, then one day there is a error:Error string: Need to run the object to perform this operation in the DTS Pump Task. This error happens once every 5-7 days. What might be happening here?Thank youRamdas NarayananRamdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-29 : 12:49:42
|
| I googled the error and also looked it up in MS' knowledge base. I couldn't find anything except for a thread at dbforums that didn't get answered. It doesn't appear to be a SQL Server error. Could the error be coming from the datasource connected through ODBC?Tara |
 |
|
|
|
|
|
DTS Pump Task