SSIS Package Configuration issues
Hi All,I'm having issues running the package using the configuration file. Below are the steps which I've followed1. Creted the package with configuration file in "C:\program files\ssis\bin\"2. Copied the package and the config file to a different machine and provided the path [Local machine path].Package is still looking for the path in step and throws a warning saying the config file doesn't exist. Looks like I'm missing somethingAppreciate all your help.Rgds,Prashanth
February 3rd, 2010 4:14pm

How are you running the package? If you are just running it by double clicking the package(DTExecUI) Are you providing the details as to where is the config file palced?Hope this helps !! Sudeep| My Blog
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2010 4:25pm

Here are the steps I'm following.Double click my package orders.dtsx. In General - Package : Full path to the package In Configurations : Adding the config fileWhen I press execute, I'm getting the warning saying the file doesn't exist [Since its expecting the file at the time package is created].
February 3rd, 2010 5:16pm

It fails after the warnings. Here's the information from the utility...Warning: The configuration file "...." cannot be found Warning: Failed to load atleast one of the configuration entries for the package. Check configuration entries for "..." and previous warnings to see descriptions of which configuration failed.Validation has startedData Flow TaskError: SSIS Error code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2010 5:55pm

It didn't fail because of the warning. It failed as a result of something else gone awry. You may have a connection string or password problem in the config file for the connection manager.Including the full messages would be helpful.Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
February 3rd, 2010 6:08pm

There is now an open source utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS or manually editing the package XML: http://ssisconfigeditor.codeplex.com/
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2012 2:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics