Dtsrun Error 2147217900

360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States)‎ Terms of use Privacy & cookies Trademarks © 2016 Microsoft

for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > MS SQL 2000 (Jobs) recurrent error message (Error = -2147217900 (80040E14)) Want to Advertise Here? Solved MS SQL 2000 (Jobs) recurrent error message (Error = -2147217900 (80040E14)) Posted on 2008-10-21 MS SQL https://support.microsoft.com/en-us/kb/308801 Server 1 Verified Solution 2 Comments 541 Views Last Modified: 2013-11-30 Hi! We have 200 - 300 Jobs programmed in MS SQL Server 2000 that run different Data Transformation Services packages at different times of the day -mainly reports. We've come up with a recurrent error, at least 10 times a day with different jobs. When looking at the Job History for the error, it goes like this: https://www.experts-exchange.com/questions/23832597/MS-SQL-2000-Jobs-recurrent-error-message-Error-2147217900-80040E14.html Executed as user: [can't tell]\Administrator. ..... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSActiveScriptTask_5 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_5 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_3 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14) Error string: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Error source: Microsoft OLE DB Provider for SQL Server . The step failed. We do pass information from SQL Server to Excel files ('Microsoft.Jet.OLEDB.4.0') at some point in our queries. But, how come it works most of the time, and all sudden reporte failures? The part of the query we use follows. Thank you for your help. --we pass a parameter that tells where the Excel file is "@filepath" declare @DataSource varchar(600) set @DataSource = 'Excel 8.0;HDR=NO;Database='+ @FilePath + ';' exec (' insert into OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''' + @DataSource + ''', ''SELECT * FROM [Sheet1$A4:L4]'') select * from dbo.temp_Table

New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 DTS failing(very urgent) http://forums.databasejournal.com/showthread.php?10786-DTS-failing(very-urgent) If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of dtsrun error 3 Thread: DTS failing(very urgent) Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-13-2002,09:20 AM #1 fluvio Guest DTS failing(very urgent) Sql Guru's, I have some DTS packages some times failing.one day sucess and next day it's failing. The dtsrun error 2147217900 following error showing. DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147217900 (80040E14) Error string: OLE DB provider 'SQLOLEDB' reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider 'SQLOLEDB' reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 7312 (1C90) Error string: [OLE/DB provider returned message: Timeout expired] Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRu... Process Exit Code 1. The step failed. Any body help me. This is very urgent Reply With Quote 02-13-2002,12:09 PM #2 Nag Guest DTS failing(very urgent) (reply) Looks like, it is a time-out issue. Try increasing the time in the DTS Package and see if it still gives out the same error. --------