We help IT Professionals succeed at work.

SSIS Package error

iI get the following error in error log sometimes only when tmy SSIS package is running. Please help:

"SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "W2K3-VSI-SA" failed with error code 0xC0202009."

Raj
Comment
Watch Question

Commented:
Is this been called from sql server job?Are both SSIS and sql server on the same server or different server?
Technical MAnager
Commented:
can you please check wheather do u have the sufficient access and also check the below

Where are you setting this connection? In the connection string are you passing password or windows authentication?? If windows auth does your id have access to the resource??

For SQL Authentication .. u need to save your password before deployment

Author

Commented:
Thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.