I'd like to keep some settings for my DTS packages like the name of the
server ,the name of database and also some other settings.I'd like to use a
table.How should the table look like ,shall I use one Table for keeping
categories and the other one for settings in that category? My DTS package
use a lot of settings,but I have classified them into diffenet category.now
I handle it using different sections in an INI file,but operation guys are
complaining about etra file to be deployed.Any idea?

Thanks

It is really up to you and DTS Couldn't really care what the table looks
like.

I personally do something like

LookupDescr, Descr, ReturnValue

and the data within may look like

SourceForFXRatesServer,This server holds the FX Rates for the ETL load,
FXSourceServ01



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ray5531" <Ray5531 (AT) microsoft (DOT) com> wrote

Hi Allan,

Do you follow up with my other posts called "
Re: Scheduled Package dose not being instanciated more than once".Thanks a
lot

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