Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?
Take a look at
http://msdn.microsoft.com/library/de...other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>
|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:

>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>