I have a dtsx package that fails to run. When I turn on logging I get:
The AcquireConnection method call to the connection manager "MY_DSN" failed with error code 0xC0202009.
MY_DSN is a legitimate DSN and my user has access to the database.
I don't see any messages in the SQL Profiler. I am tracing for the following:
- Audit Login
- Audit Logout
- Existing sessions
- PreConnect Complete
- PreConnect Started.
What other diagnostic tools should I be using to be getting more useful error messages?