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

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].
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2010 5:16pm

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]. You are adding a NEW configuration file this way. The warning message is just a warning though - you can ignore it. The package config you are specifying is correctly working though.Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
February 3rd, 2010 5:36pm

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

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

Other recent topics Other recent topics