sql server dts: Over the time we have been using DTS, our tean has acuminated a lot of packages and sometimes more than one package for a job. Just wonder if there's anyway to have a more organized way of saving the packages (i.e. folders) so we can manage the packages easier

Would be nice wouldn't it but No.

Only way I do it is I start packages that work on the same projects with the
same prefix so they sort correctly.

If you want to see this feature maybe in a future version of SQL Server you
can send a mail to sqlwish@microsoft.com



--

----------------------------

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


[quoted text, click to view]
packages and sometimes more than one package for a job. Just wonder if
there's anyway to have a more organized way of saving the packages (i.e.
folders) so we can manage the packages easier.
[quoted text, click to view]

In message <eaIjAlWFEHA.2160@TK2MSFTNGP12.phx.gbl>, Allan Mitchell
<allan@no-spam.sqldts.com> writes
[quoted text, click to view]

I (try) and take in one step further with a couple of parts. The
segmented name idea, goes something like this-

<Project> : <Function> : <Procedure>
StockControl : Reporting : Board
StockControl : Loading : SuppliersDaily

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org