Super newbie question...

I'd like to launch a DTS package from a client via a batch file.

Any advice is much appreciated!!

-Sean

You might want to take a look here: http://www.sqldts.com

--
Andrew J. Kelly SQL MVP


"Sean Gallagher" <swgallagher (AT) hinet (DOT) org> wrote

Thanks Andrew for pointing Sean to the site.

In a batch file you will want to use DTSRUN. Full syntax can be found in
BOL or even on the web.

http://msdn.microsoft.com/library/de...tsrun_95kp.asp

remember though DTS is fired on the client so you will need the Dlls on the
client machine as well.

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

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
"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Thanks for the link!!

Anyone else looking for this info:
start | run | rundtsui

Connect to DB, and find package

Advanced

Generate script.

Copy the script and their you go...



swgallagher (AT) hinet (DOT) org (Sean Gallagher) wrote in message news:<40c50523.0407011405.2c23dc8a (AT) posting (DOT) google.com>...

In article <40c50523.0407061325.1cdfe137 (AT) posting (DOT) google.com>, Sean
Gallagher wrote:
Just a quick note.

That should read

start | run | dtsrunui


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org