Not able to run The SSIS Package in SQL Job agent where as it runs fine in VS

0

I have a SSIS package which loads data from a Excel file in SQL Table. It runs fine when we run it from VS but it does not works in SQL Job agent.

It fails with bellow error:

Message:

Microsoft (R) SQL Server Execute Package Utility Version 12.0.5589.7 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 4:16:15 AM Error: 2018-09-20 04:16:16.42 Code: 0xC0209303 Source: Package Connection manager "Factor File"
Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.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". End Error Error: 2018-09-20 04:16:16.42 Code: 0xC020801C Source: Loads Factor Files CDF [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Factor File" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2018-09-20 04:16:16.42 Code: 0xC0047017 Source: Loads Factor Files SSIS.Pipeline
Description: CDF failed validation and returned error code 0xC020801C. End Error Error: 2018-09-20 04:16:16.42 Code: 0xC004700C
Source: Loads Factor Files SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2018-09-20 04:16:16.42 Code: 0xC0024107 Source: Loads Factor Files

After searching on Google I have tried few solutions like:

Setting project debugging mode to 64 bit False, Change package execution mode to 32 bit and installing MS access driver 2010 but no Luck.

Can anyone please suggest any solution.

sql-server
ssis
asked on Stack Overflow Sep 20, 2018 by Sonali Nimkarde • edited Sep 20, 2018 by Birel

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0