November 17, 2014 at 1:07 am
Hi Experts,
In one our requirement, we need to develop SSIS package that will create Excel file dynamically and populate that Excel from SQL Server tables. We created the package and it is working fine in designer mode.
While deploying the package in SQL job, it is throwing error mentioned below.
[Connection manager "ExcelConnectionManager"] Error: 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".
Since Job is executing in 64-bit mode it failed. How to resolve the issue? I have tried installing 64-bit JET driver for Excel but it did not give any changes.
Please suggest...
Thanks in advance..
Debanjan
November 17, 2014 at 1:11 am
Try configuring the SQL Agent job to run the package in 32-bit mode in the Configuration / Advanced section of the Job Step properties.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply