SSIS issue...OLE DB Destination [21]] Error

Hi ,
I have created a SSIS package while running it . I am getting errors while package execution is in progress :


1)
[OLE DB Destination [21]] Error: The AcquireConnection method call to the connection manager "<Connection Manager Name>" failed with error code 0xC0202009.

If anybody has faced such error please send me the way to resolve it .
Its urgent..


Rohit Kochar
MCP .Net(Web and SqlServer)
Company : TCS ,Noida

Hi ,
Surprised dint get any response...anyways i choose package protection level option
as 'encrypt all data with password ' . I am not getting any error in this case .
But how to enter password when i run SSIS this through a command prompt??? .
suggestion most welcome .


Rohit Kochar
MCP .Net(Web and SqlServer)
Company : TCS ,Noida

Things are a bit quiet on SSP today, which can be frustrating if you're in a spot of bother. And then you get a response from someone who doesn't know much about SSIS ...

... but the bit about encryption makes sense. Surely there is SOMETHING on the subject to be found in Books Online?

Hi ,
The problem is solved...There is a option in SSIS package "Edit command line manually".
I have set the password in the command arguments ....now it is not asking for password
when I am executing it from command prompt...


Rohit Kochar
MCP .Net(Web and SqlServer)
Company : TCS ,Noida