SQL Server Performance

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

Discussion in 'SQL Server 2005 Integration Services' started by rohitkochar, Jun 5, 2007.

  1. rohitkochar New Member

    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
  2. rohitkochar New Member

    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
  3. Adriaan New Member

    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?
  4. rohitkochar New Member

    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

Share This Page