I am trying to add a configuration file to an existing job in the SQL Server Agent. I am trying to figure out where the files get saved after you deploy them to the SQL Server System. I have been successful doing this and I have been successful running the package as a Job, but I want to add a configuration file and do not know how to find it in the SQL Server System. I am not even able to see the existing configuration file through the Configuration Tab of the job. Any help will be greatly appreciated. Thank you!

The following article addresses the issue (/CONF switch in DTEXEC): Similarly, you have an option to designate an arbitrary configuration file that is supposed to be applied prior to package execution (via /CONF switch). However, you should keep in mind that any settings assigned via existing configurations (defined at the design time and included in the package via Package Configuration Organizer) will always take precedence over those used in combination with /SET, /COM, or /CONF switches of DTExec (DTExecUI is a subject to the same rule). This is because configurations included in the package are applied twice, before and after settings specified via either of these two utilities are taken into account. Such design, while somewhat inflexible, gives you the ability to assign desired values directly at the invocation time, as long as they do not conflict with those already present in existing configurations. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

The following article addresses the issue (/CONF switch in DTEXEC): Similarly, you have an option to designate an arbitrary configuration file that is supposed to be applied prior to package execution (via /CONF switch). However, you should keep in mind that any settings assigned via existing configurations (defined at the design time and included in the package via Package Configuration Organizer) will always take precedence over those used in combination with /SET, /COM, or /CONF switches of DTExec (DTExecUI is a subject to the same rule). This is because configurations included in the package are applied twice, before and after settings specified via either of these two utilities are taken into account. Such design, while somewhat inflexible, gives you the ability to assign desired values directly at the invocation time, as long as they do not conflict with those already present in existing configurations. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

you did mention config file NOT config table and how to find it http://msdn.microsoft.com/en-us/library/ms162810.aspx 1- you have to know if you have a config file and where it is and if not you can make one by openning the package in BIDS , they have a *.dtsConfig format and they are an XML as i mentioned 2- the sample looks like as mentoined in you r JOB (Script the job and youll see ) DTEXEC /FILE ' C:\PKGName.dtsx ' /CONFIGFILE C:\SSIS-XmlDestinationDBConfig-PKGName.dtsConfig /CONFIGFILE C:\SSIS-XmlFolderConfig-PKGName.dtsConfig You can have multiple config files when calling a package Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

I want to know where it stores the files (including existing Config files) once you deploy to the SSIS file system,.

If you are talking about the XML files, YOU are soring them by copying them to a folder on production server , or if you are deploying the package in BIDS on production server you can MAKE the xml files within BIDS and save it anyware you want see how to make a XML config file for SSIS pacakges at http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm http://www.mssqltips.com/tip.asp?tip=1434 http://www.programmersedge.com/?p=56Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).