Error while invoking AcquireConnections(null)

Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the

Instance.AcquireConnections(null);

The connection string that is given for the connection manager is as follows

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"

What is the wrong here-can any body kindly suggest? I have tried with the following too

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"

Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.

You can use SQL authentication in SSIS. Remove "Integrated Security = SSPI;", and replace it with "Uid=myUsername;Pwd=myPassword;"

Try this link for help with connection strings: http://www.connectionstrings.com/

|||Do you think I need to use the "provider=SQLNCLI.1 ; auto translate = false" when I will use the SQL authentications? I meant if I use the user id and password instead of "ntegrated Security = SSPI" should I remove the provider and auto translate attributes or I need to keep them?|||You'll need to keep them. The provider determines which OLEDB driver you are using - if you omit it, the connect string won't be valid. Auto translate is optional, but I'd leave it in there.|||

Thanks much!