SQL Server Performance Forum – Threads Archive

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

---

]]>