x

I have a script runs every day. Its takes data from an excel sheet and updates a sql database. We move to a new sql server and it does not work. Can someone help?

Here is the error:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

04/22/2015 10:58:19,_ssis_planner_ship_date,Error,0,SL-SQL,_ssis_planner_ship_date,(Job outcome),,The job failed. The Job was invoked by User INFORMATION\becker. The last step to run was step 1 (planner_ship_date_WKC). The job was requested to start at step 1 (planner_ship_date_WKC). NOTE: Failed to notify 'Hank Becker' via email.,00:00:01,0,0,,,,0

04/22/2015 10:58:19,_ssis_planner_ship_date,Error,1,SL-SQL,_ssis_planner_ship_date,planner_ship_date_WKC,,Executed as user: INFORMATION\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4033.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:58:19 AM Error: 2015-04-22 10:58:20.70 Code: 0xC0202009 Source: Planner_Ship_Date Connection manager "con_Excel_File" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine could not find the object '\\innovate\SQLdts\Planner Ship Date Script WKC.xls'. Make sure the object exists and that you spell its name and the path name correctly.". End Error Error: 2015-04-22 10:58:20.70 Code: 0xC020801C Source: df_copy_excel_data_2_sql_table src_Excel_Data_File [54] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "con_Excel_File" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2015-04-22 10:58:20.70 Code: 0xC0047017 Source: df_copy_excel_data_2_sql_table SSIS.Pipeline Description: component "src_Excel_Data_File" (54) failed validation and returned error code 0xC020801C. End Error Error: 2015-04-22 10:58:20.70 Code: 0xC004700C Source: df_copy_excel_data_2_sql_table SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2015-04-22 10:58:20.70 Code: 0xC0024107 Source: df_copy_excel_data_2_sql_table Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:58:19 AM Finished: 10:58:20 AM Elapsed: 1.638 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

more ▼

asked Apr 23, 2015 at 10:51 PM in Default

avatar image

atomic3367
1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I think that you have problem with permissions on share folder \\innovate\SQLdts. Someone don't have permission to access Excel file or share folder.

But first check if your Excel file exist in this location:

"The Microsoft Jet database engine could not find the object '\\innovate\SQLdts\Planner Ship Date Script WKC.xls'. Make sure the object exists and that you spell its name and the path name correctly."

one possible problem is if your new server is 64bit. Since there's no Jet Driver for 64bit systems, when running on a 64bit OS you need to either use the 32bit DTEXEC in your sql job or set the "Use 32bit runtime" option, it's on the "Execution options" tab when you're creating a SSIS job step, check the image on link below for seeing it

Picture

And another one great article for job troubleshooting:

https://social.technet.microsoft.com/Forums/sqlserver/en-US/e13c137c-1535-4475-8c2f-c7e6e7d125fc/how-do-i-troubleshoot-ssis-packages-failed-execution-in-a-sql-agent-job?forum=sqlintegrationservices

more ▼

answered Apr 24, 2015 at 06:40 AM

avatar image

Sule
1.1k 3 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x780

asked: Apr 23, 2015 at 10:51 PM

Seen: 195 times

Last Updated: Apr 24, 2015 at 12:00 PM

Copyright 2017 Redgate Software. Privacy Policy