HI All.. let me rewrite my question.. this might help me to resolve my exact issue.. i just used a "OLEDB" destination.. and used windows authenticaion for connecting to a local DB. its worked fine then i created SSIS package configurtion -- its worked then i used SQL authentication , instead of windows authentication - then its worked then i created SSIS package configuration -- not working below is the error message-- ======================================================== TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [OLE DB Destination [673]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "testDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error at Data Flow Task [SSIS.Pipeline]: component "OLE DB Destination" (673) failed validation and returned error code 0xC020801C. Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. Error at Package [Connection manager "testDB"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'DS\KasthurK'.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ BUTTONS: OK ------------------------------ Thaks, Kranthi Kumar. K

Can you put config file connection string that is assign to variable with dummy server name and all so we can undersant exact issue SUHAS R. KUDEKAR http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

What is the package protection level? According to the setting of this property, sensitive data (such as the passwords for a connectionstring) are saved or not in the package.MCTS, MCITP - Please mark posts as answered where appropriate.

Do you use XML configuration? Go to the confg file. open in internet explorer and check if password is mentioned for 'DS\KasthurK' user. Usually when config is created, password info gets deleted and u need to give it manually. If password is not there, then open the config file as notead and add password. "User id='DS\KasthurK';Password=psswrd; and for Password tag below, add the same 'psswrd' between <ConfiguredValue>psswrd</ConfiguredValue> This shoud solve your issue. Whether you use xml confg or not, this error is only because the password is not mentioned for the user. Hope this helps. Please mark as answer if this solves your problem.