"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23NOaruudFHA.1040@TK2MSFTNGP10.phx.gbl...
> 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@microsoft.com> wrote in message
> news:%23zQrKrsdFHA.2076@TK2MSFTNGP15.phx.gbl...
>> 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
>>
>
>

"Ray5531" <Ray5531@microsoft.com> wrote in message
news:%23zQrKrsdFHA.2076@TK2MSFTNGP15.phx.gbl...
> 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
>