I have a single SQL Server 2000 installed on my server but there are more
than one users that building their own DTS packages on that machine. Is there
any way that I can make a separate repository of the DTS Packages for each
user/database

--
Thanks
Akber.

No. You can each store your packages on a separate file system folder
though.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote

You can't create separate repositories in SQL Server for users and
databases, but you can save DTS packages as structured storage files on the
file system, so you could set up folders for users and databases, and apply
security to those folders if that's an issue.
I generally prefix the name of the dts package when saving it on SQL Server
with an acronym of some sort to describe the project or database it relates
to, so I can find packages faster on systems that contain hundreds of
packages.

"Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote