i developped an SSIS package and its working fine with out creating SSIS package configuraions. i used OLEDB destination component, flat file source, execute sql , execute t-sql components. ( here am using Remote DB, not local DB) am able to create create package configuraions. then..if i try to run it..its throwing eror messages.. the issue is specifically because of connection managers.. if i remove related configs form config setting. then is worksThaks, Kranthi Kumar. K

And the error message is bleow =================================== Error at Data Flow Task - Not processed or failed to process files [OLE DB Destination [345]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "CVRCA-DB03.DMV_Auditing.sa" 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 - Not processed or failed to process files [SSIS.Pipeline]: component "OLE DB Destination" (345) failed validation and returned error code 0xC020801C. Error at Data Flow Task - Not processed or failed to process files [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task - Not processed or failed to process files: There were errors during task validation. Error at AuditingPackage [Connection manager "ole DB connection "]: 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 'ka'.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ Program Location: at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, DataWarehouseProjectManager manager, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options) Thaks, Kranthi Kumar. K

when you add package configuration, you should set up your connections again.http://www.rad.pasfu.com

when you add package configuration, you should set up your connections again.http://www.rad.pasfu.com

hello dint helped ... need other solution. Thaks, Kranthi Kumar. K

Hi Kranthi, 1) Are the values of the connection managers when there were no configurations in the package same as when there are configurations? 2) Also, check the validiity of the values when the configurations are applied in the package.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

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

What kind of server u r trying to connect to ? 2) Try running it from the command prompt of the job to check if it runs with 32bit environment. 3) To validate if the password is coming successfully , print the connection string of the connection manager using a script task.

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.

sql server 2008 r2Thaks, Kranthi Kumar. K