Hi

Maybe someone can suggest a better way of doing this:

I have DTS Packages to load data into a data warehouse, and the
packages fetch settings from an INI file. I want to move the packages
up from DEV to STAGING then to LIVE. Each time, the directory
structure will be different, so the path for the INI file will change.
At the moment, for every task-setting that needs to be set, I fetch
the value from the INI file, but for each setting (and there are
several) I have to enter the INI file path & name.

This means that each time I have to move a package from DEV to
STAGING, or STAGING to LIVE, I have to manually change the path &
filename of the INI file for EVERY dynamic setting. This seems to
defeat the point. Is there some way that I can dynamically set the
source of a dynamic setting?

Thanks
Sean

You can probably reverse engineer this

How to add a Dynamic Properties task to a package and manipulate it using
VB.
(http://www.sqldts.com/default.aspx?252)



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sean Walsh" <plugNOwalshSPAM (AT) yahoo (DOT) com> wrote

Set it with a variable and use ActiveX task to read the file. Pass the value
using dtsrun.exe.

"Sean Walsh" <plugNOwalshSPAM (AT) yahoo (DOT) com> wrote