I moved one of the ssis packages from dev to prod.
Did the same for the configuration file which contains the connectionstring.
Now I would like to run the package in live but the error is:
Description: The configuration file name "S:\Imports\Trades\Environment.dtsConfig" is not valid. Check the configuration file name.
The file does indeed exist and the connectionstring has the correct string.
Any thoughts please?
How are you executing the package? If via 'SQL Agent' then you need to specify the CONFIG file in the command line, i.e. : - DTEXEC /FILE "<<MyFullPackagePath>>" /CONFIGFILE "<<MyFullConfigPath" /CHECKPOINTING OFF
No comments:
Post a Comment