SQL Server Performance

How to change the location of a configuration file

Discussion in 'SQL Server DTS-Related Questions' started by Bartuls, Jun 14, 2004.

  1. Bartuls New Member

    In a DTS package I use a configuration file (.INI file) to store some environment related variables (location of files etc.).
    The first task in the package is a dynamic properties task, setting some globals and task properties to the values supplied in the configuration file.

    Every time the package is changed in our development environment and it is copied to the acceptation and production environment the location of the configuration file has to be changed manualy to refer to the location this file is stored in those environments (for every line in the dynamic properties task!).

    Is it possible, using a dynamic properties task or an ActiveX Script Task, to set the location and name of the configuration file?


Share This Page