I use dynamic properties with my .INI file for setting things like
connection strings, file paths, etc. However, I'm trying to figure out how
to write data back to my .INI file from a DTS package. I have a run-date
key/value pair that must be updated after each successful run of the DTS
package.

Is there a way to do this from one of the DTS tasks? If not, what are most
folks doing to solve this problem? I know that saving it to one of the
global variables isn't practical. I could store it to a SQL table but I
desire to keep all my configuration data together in one place, hence the
use of an .INI file.

Thanks,

Scott Stubbs

AFAIK you cannot write back to the INI file. You could build a custom task
which uses one of the APIs for writing to INI files.

http://www.thescarms.com/vbasic/registry.asp

--
--

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


"Scott Stubbs" <sestubbs (AT) nospam (DOT) com> wrote

Allan,

I'm not supprised. I wish that Microsoft had provided full functionality
for INI files. While I'm at it... I wish that Microsoft had provided full
functionality for FTP too.

I realize there are components out there to do the job, I just have a
customer with some strict policies on using 3rd party components.

BTW, thanks for the link! That will come in handy for a future project.

Regards,

Scott Stubbs

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote