Hi, I created simple pakage with OLEDB source and OLEDB destination. In this package The source points to database in my local server whereas destination is a database in different domain, the server is in USA. I created Connection Manager for destination db with SQL server Authentication mode by providing username and password. I executed the package the package worked fine. Then I created one more similar package where I added 4 variables @Server, @database, @Username and @Password and configured same value s in the variable which I used in connecting remote db with sql Server Authentication mode. in connection manager expression field i gave the below values: "Data Source="+ @[User::Server] + ";Initial Catalog=" + @[User::database] +";user id ="+ @[User::Username] +"; password=" + @[User::Password] + ";Provider=SQLNCLI10.1;Integrated Security= SSPI;" But now the package fils with the below error message: [OLE DB Destination [20]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Loop" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Please advice me. Thanks V. Mahadevan

You cannot use Integrated Security = SSPI with a User ID and Password. If you want to use a User ID and Pasword set Integrated Security = false Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

did you set DEFAULT VALUEs for variables? put some default valid values, or set DelayValidation to true.http://www.rad.pasfu.com

Hi, I was able to overcome the issue by using below value in Expression field of data connection manager: "Provider=SQLNCLI10.1;Data Source="+ @[User::LoopServer] +";Persist Security Info=True;Password="+ @[User::Password] +";User ID="+ @[User::Username] +";Initial Catalog="+ @[User::LoopDB] +";" See: http://mahadevanrv.blogspot.com/2011/05/how-to-connect-multiple-datasources-in.html ThanksV. Mahadevan