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

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

Other recent topics Other recent topics