Jon Jaroska (12/28/2012)
The package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
The AcquireConnection method call to the connection manager glxy_epace.epace_read failed with error code 0xC0014009.
OK - but I asked whether the package ran in BIDS on the server.
Can you try logging in as the user under which the SQL Agent service is running and then executing the package in BIDS again (on the server)?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.