package - .dtsconfig File Location -


I am trying to change a scheduled task that runs the .dtsx file with the same .dtsx file , Is modified.

I want to use the same .dtsxonfig file as the old package, but I do not know where it is located. How do I get the location of the config file? How can I make sure that the new package will reference it?

If the existing SQL Agent provides a clear path to job configuration, then the job phase is in that list (Get details from the command line tab).

Otherwise, look in the package. View a configuration type of SSIS, package configuration ... and XML configuration file

update

, in your control flow, right click on the background and In the context sensitive menu, select package configuration ... , if they turn on the configuration, then I can check the "Enable package configuration" check box and the depth of the section below Can not be from

With XML configuration, you get two options with it. The first (sample) is what is known as the direct configuration. You can see that the configuration string specifies a specific location on the disk that will check if the package is running. Second (xmlen) option indicates indirect configuration This is an environmental variable, SSIS_CONFIG in my example, works to determine the location of the .dtsConfig file

 Enter the image details here

If you do not see anything listed in the Package Configuration section, then you can assume that they are run- Some different methods of completing the configuration are being implemented in time , So I ask your DBA that describes specific steps for Integration Services job agent.

Comments