question

DaveF33-2356 avatar image
0 Votes"
DaveF33-2356 asked ZoeHui-MSFT commented

Loading Excel files with data (data flow task) fails following migration to new server

We recently migrated our SSIS projects from Visual Studio 12 to Visual Studio 19.
I imported all of the projects successfully into the new server via Visual Studio 19

They all work fine with one exception. The SSIS packages that update data into an excel file all fail.
I was hoping it was a 64bit/32bit issue so I made sure they were set to 32-bit, but that did not help.
I am hoping you can point me in the right direction as I am on my own with this one.

I am guessing that perhaps the DBA did not include either the 32-bit or 64-bit drivers?

Here are the errors I get: (copied from the Progress tab):

  1. [Excel Destination [92]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 3" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

  2. [SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.

  3. [SSIS.Pipeline] Error: One or more component failed validation.

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

5.[Connection manager "Excel Connection Manager 3"] Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816

Thanks in advance for your assistance! I am hoping you can point me in the right direction.





sql-server-integration-services
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.

1 Answer

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @DaveF33-2356.

When you design your package within SSDT, you’re using a 32-bit process, which can only use 32-bit providers.

You may need to install 32 bit version of Microsoft Access Database Engine 2010 Redistributable.

Uninstall 64 bit version if previously installed.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

If you want to Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing, refer here.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.


· 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.

It worked. Thank You

0 Votes 0 ·

Hi @DaveF33-2356.
You could click "Accept Answer" on the reply so other users with similar problem could see this easier. :)

0 Votes 0 ·