AcquireConnection method call fails - Excel

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I already have two packages that load this Excel File and I have had no issues.

I'm wondering if the package is corrupt?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I did not change the package to run in 32 bit mode.

I have ran SSIS Packages in 64 bit on older OS's and it was not an issue however when I deployed the package I had to set it 32 bit.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 3

SSC Guru

Points: 182948

November 22, 2016 at 10:52 am

Are your drivers up do date?

😎

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Eirikur Eiriksson (11/22/2016)
Are your drivers up do date?
😎

That could be the issue.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/