Dts Error 2147467259
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server 2000 - dts error 2147467259 80004005 DTS Package Failure - Error: -2147467259 (80004005); Timeout expired SQL Server
Error 2147467259 Sql
> SQL Server Integration Services Question 0 Sign in to vote Hi All, I've had a error 2147467259 odbc DTS Package scheduled to run every morning since June last year, however on Monday and again this morning, the DTS package has failed on two of its steps. This DTS package runs on SQL Server 2000 and the server is a Windows 2000 Server. Basically, the DTS Package steps that fail are populating a "cache" table from a "live" table and then performing Inserts / Updates on the "live" table from a CSV file depending upon whether data exists in the "cache" table and whether the CSV file contains an "Insert" or "Update" flag. The live table has just over 800,000 rows of data and our nightly CSV extract, containing both inserts and updates, has about 6000 rows. The error / failure has only happened in the last two days and I'm not too sure if there's any "timeout" feature in DTS and if there is, how I can modify it, or whether this may be something to do with long transactions or temp dbspace running out. The time that the DTS package runs was modified last week to run two hours earlier (03:00 instead of 05:00) and has ran okay for a few days. I don't know whether this change is a red herring, as I have checked other DTS packages on the machine and none appear to run at the same time. Here's the message from the third step in the DTS Package (second one that's failing). Executed as user: SOE\incaservice. ...Start: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10 DTSRun OnError: DTSStep_DTSExecuteSQLTa
van GoogleInloggenVerborgen veldenZoeken naar groepen of berichten
SQL Server experts to answer whatever question you can come up with. Our new SQL http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104999 Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) -2147467259 (80004005) error 2147467259 Timeout expired Reply to Topic Printer Friendly Author Topic Ganeshk Starting Member 6 Posts Posted-06/17/2008: 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 dts error 2147467259 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 USA 38200 Posts Posted-06/17/2008: 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-06/18/2008: 12:15:30 Thanks Tara,I am trying to make a sense out of this. visakh16 Very Important crosS Applying yaK Herder India 52326 Posts Posted-06/18/2008: 13:12:03 quote:Originally posted by GaneshkThanks Tara,I am tryin