question

AmyJandreau-8392 avatar image
0 Votes"
AmyJandreau-8392 asked Monalv-msft edited

SQL Server scheduled Job failing

Hi All
I have an SSIS Package that i scheduled as a SQL Server job. The job has been failing lately all of a sudden. The error message i get is the excel work book has been opened, which is not the case as i made sure it is closed. Please advice.
Thanks

sql-server-generalsql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@AmyJandreau-8392,
Please share overall failing SSIS package design. and a complete error message.

0 Votes 0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @AmyJandreau-8392 ,

Please share more detailed error messages in the job View History.

Please check if you run ssis package in other progress at the same time.

78104-job-viewhistory.png
78121-jobhistory.png

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





job-viewhistory.png (13.3 KiB)
jobhistory.png (74.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmyJandreau-8392 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·

Hi All
Sorry for the delay , i wanted to trouble shoot before i post it here. I created a new SSIS project which is an exact copy of the old package. The package runs fine from VS but fails from the SQL Server. job failed with the below error messages. The error messages do not make any sense as i have excel drivers installed and there are other jobs using excel that run on the same server.

Data Flow Task:Error: SSIS Error Code

LoadAPCCFinancials:Error: The requested OLE DB
provider Microsoft.ACE.OLEDB.12.0 is not registered. If
the 64-bit driver is not installed, run the package in 32-bit
mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE
DB Service Components" Hresult: 0x80040154
Description: "Class not registered".

0 Votes 0 ·