Executing package with a configuration

• Alexander G.

  SSCrazy

  Points: 2705

  More actions

  October 1, 2010 at 8:35 am

  #229962

  Hi,

  I have a package for which I have set the configuration file to be in C:\FWS\FWS.dtsConfig in BIDS.

  The package has been deployed an set up to be executed by an sql server agent job and runs fine as long as the configuration file is located in C:\FWS\FWS.dtsConfig.

  Now I have to change the configuration path to be D:\FWS\FWS.dtsConfig. I thought I could use the unchanged package and set the configuration file path within the job step to D:.

  When trying to execute the job I get error messages like

  The file name property is not valid. The file name is a device or contains invalid characters.

  although all relevant Raw File Targets and Data Flow Tasks have been set to ValidateExternalMetadata=false/DelayValidation=true.

  So it seems that the D:\FWS\FWS.dtsConfig that contains the correct settings cannot be found. When I copy the file to D:\FWS\FWS.dtsConfig, all is fine.

  So I have two questions:

• What is the purpose of setting the configuration path in the job step (i. e. dtexec)? Is this not a recommended method if the actual config path has to be changed from the path at development time?
• Why do these errors show up at the first validation of the package even if the validation of the tasks should be delayed?