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 |
Ganeshk
Starting Member
6 Posts |
Posted - 2008-06-17 : 12:13:11
|
Hi All,I have a DTS package that runs at every 3 minutes and it has many more than 20 steps. Most of the steps are again, some DTS. It had failed randomly on few occasions in past few days at different steps.The error message that it throws is as following:'DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.'There are some closely resembling articles available in this forum, still, it is different due to 'timeout expired' error. Using SQL server 2000 SP4.Appreciate your quick replies here. Thanks. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-17 : 12:52:04
|
Either make them more efficient or set the timeout value higher. I believe you can do it in the disconnected properties, but it's been a long time since I've touched DTS.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
Ganeshk
Starting Member
6 Posts |
Posted - 2008-06-18 : 12:15:30
|
Thanks Tara,I am trying to make a sense out of this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-18 : 13:12:03
|
quote: Originally posted by Ganeshk Thanks Tara,I am trying to make a sense out of this.
Are there some large chunks of data transfer happening? |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-06-18 : 13:41:20
|
Hey Ganeshk, I used to work with a guy named Ganesh and his last name began with a K. Did you by chance ever work in Kentucky? |
|
|
Ganeshk
Starting Member
6 Posts |
Posted - 2008-06-23 : 14:24:09
|
Hi Tara - can you please tell something more about disconnected properties?Hi Visakh - Nice to hear from you. Its not really large chunk of data. The data gets imported is very small, and get pulled at every three minutes. Its more about the high priority to this data, so that user can start working immediately on the data recieved.Hi Van - No, I have not been so lucky, as of now to work in Kentucky.I am not that GaneshK. Btw, nice to hear from you. Keep posting. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:09:23
|
You can enable package logging, that will tell you details why packages fail. |
|
|
|
|
|
|
|