Failed to acquire connection "Excel Connection Manager".

I have just built a package which includes an excel connection manager.

It all works fine on my machine but when I deploy to the server I get an error reading

'Failed to acquire connection "Excel Connection Manager". Connection may not be configured correctly or you may not have the right permissions on this connection.'

I have read that the excel connection manager does not work with the 64bit processor.

I have the package link to an SQL Job.

How can I fix this problem.
Who is Participating?
EvilPostItConnect With a Mentor Commented:
There is a Run as 32 bit option in the sql job.
Mr_ShawAuthor Commented:

I tried running the job as a 32 bit option as it was the easiest solution.

It did not work so I ran the job as an Operating System.

This worked.

Mr_ShawAuthor Commented:
My  Operating System script was

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTEXEC.EXE" /SQL "\B_Reports\InvoicingReport" /SERVER Server1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.