sql server dts: How to Install DTS client without EM in 2000 -- sql server dts

How to Install DTS client without EM in 2000

Adam
10/5/2006 11:24:02 AM

sql server dts:

How can I install DTS without having to install Enterprise Manager in SQL
Server 2000?

From the options given through the installation process, it seems I have to
install EM in order to have DTS but my understaning is that DTS is a seperate
client tool which comes with SQL Server. I don't want to install EM on a
developer's machine.

Thanks.

Re: How to Install DTS client without EM in 2000

SimplySuzy
10/5/2006 1:40:13 PM

Hi
The only way to allow someone to create a DTS package is through
Enterprise Manager. Perhaps you can block all servers/databases if it
is a permission issue.
Suzy
[quoted text, click to view]

Re: How to Install DTS client without EM in 2000

Darren Green
10/6/2006 4:03:02 AM

You can install just the DTS runtime, which allows you to execute packages,
but has no designer. The designer is EM, so you get all tools or none.

See Redist.txt on the CD for directions of installing just the runtime.

--
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.