I have read many articles on package configuration, still I am confused. I am using sql server 2008 ssis. I have turned on package configuration for my package. I saved configuration as an xml file, config1.xml. Now I renamed config1.xml to devconfig1.xml, edit it so variables, ole db point to my dev environment. Now I run my package using dtexec /conf devconfg1.xml /File package.dtsx When I run this dtexec command, I am setting it is still looking for config1.xml (I see several warnings) but because config1.xml is no longer there it uses devconfg1.xl I think. I went to my package, package configuration, package configuration is checked, then I removed config1, but package config is still checked. Questions: When I run dtexec, again I still get various warning messages. Is there any way to get rid of warning messages.Is there any debugging option for dtexec to see which configuration variables etc. are being picked from the devconfig1.xml file, because I do not see package is picking a variable for mailSubject (I have a send mail task, where I want to make Subject of mail to be a variable and set from config file). While ole db config setting etc are being picked from devconfig1.xml., mailsubject is not being picked. I need to troubleshoot this. Thanks a lot for your help.

Create a variable , and pass the connection string through the variable for that xmlconfig file..

I am alreday using variables, problem is something else!!!