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.