DTEXEC command with /ConfigFile option
Hi,
I am executing my package with DTEXEC Command, My package contains one configuration file. so I am giving the configuration option as
/ConfigFile XMLMassMutualConfiguration;"E:\Packages\ConfigurationFiles \MassMutual.dtsConfig " which is the path of the configuration file.
While design time my configuration file location is "E:\Packages\Proj1\Proj1\MassMutual.dtsConfig " this thing which is stored in the package also, after that I have moved my configuration file to
ConfigurationFilesfolder and executed through dtexec command by giving the new path but it is still showing the
warning as
The configuration file name "E:\Packages\Proj1\Proj1\MassMutual.dtsConfig" is not valid, which is old path, I don't know what happened to the new path which I have specified in dtexec command .
After that it is showing error ,acquire connection is failed.
I can't hard code config file path in package. so, i need to provide config file location dynamically while preparing dtexec command.
Can any body help me in this matter?
Thanks
December 21st, 2010 4:12am
This is as per design, so if you have a design time setting it cannot be overridden by /ConfigFile at run time. So the package tries to apply a path that does not exist and warns you. Read more on this here:
http://msdn.microsoft.com/en-us/library/bb500430.aspx
The aforementioned article also mentions how to avoid this pitfall by using a /SET command.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
December 21st, 2010 9:36am
Hi Thanks for your replay
For my command line utility how can i write set command for it.
Can you guide me with syntax
Thank you
December 22nd, 2010 3:58am
Hi,
The detailed description about dtexec is providered in the following article:
http://msdn.microsoft.com/en-us/library/ms162810.aspx
For your reference, for the /set command, below is a sample:
dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 22nd, 2010 5:12am
Hi,
The detailed description about dtexec is providered in the following article:
http://msdn.microsoft.com/en-us/library/ms162810.aspx
For your reference, for the /set command, below is a sample:
dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue
Thanks,
Jin ChenJin Chen - MSFT
December 22nd, 2010 1:10pm
Hi
What happens when I execute my package through DTEXEC Command , Which settings are loaded first,and when my package will considers the /ConfigFile XMLMassMutualConfiguration;"E:\Packages\ConfigurationFiles \MassMutual.dtsConfig "option
in the batch file,
Thanks
Free Windows Admin Tool Kit Click here and download it now
December 27th, 2010 1:03am
yes, it seems when you execute the pkg which will try to use the config file you specified during design time as its first choice then the config file you specified with "/CONFIGFILE" in batch file. it won't be a problem if you run the pkg on another
machine other than your dev machine.
if you are intreseted there is a new improvement to replace config file in SQL11 which is environment. see
http://social.technet.microsoft.com/wiki/contents/articles/sql-server-denali-ctp1-integration-services-ssis-environment-variables.aspx
December 27th, 2010 3:58am
When i read the article included as a link in your reply, I do not see how to use the "set" command to provide a new location for the configuration file. For example, let's say that at design time, the location of my dtsconfig
file is c:\ssis\config\xxxx.dtsconfig.
Not I want to use a command file to call DTEXEC and use the /set command to find the configuration file at a new location, say c:\NewLocation\SSIS\xxxx.dtsconfig/
I have tried to use /conf option, but it want to load the configuration information for the original, design time, location.
How can that be done? When i read MSDN documentation, it states "You can use the
/Set option to change the location from which package configurations are loaded." To me it means that i can specify a new location for the config file. Am I misunderstanding how to do this?
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 2:00pm
Check the path.Arthur My Blog
July 7th, 2011 2:04pm