Executing DTS packages from SQL SRVR 7.0 Stored Proc

#1

HI:
does anyone know it this can be done ?
if so, can you please share the basics and maybe some
sample code

((i am also interested in executing a DTS package from
ACCESS'97))

thanks

#2

1. Look at the sp_OA* stored procs or DTSRUN
2. Register the dlls and use the object model

Execution
(http://www.sqldts.com/Default.aspx?104)

--
--

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

"VernDegeus" <vern.degeus (AT) harley-davidson (DOT) com> wrote

Quote:

HI:
does anyone know it this can be done ?
if so, can you please share the basics and maybe some
sample code

((i am also interested in executing a DTS package from
ACCESS'97))

thanks

#3

look at dtsrun

exec master..xp_cmdshell 'dtsrun /Nmypackage'

also see
http://www.nigelrivett.net/sp_oacrea...TSpackage.html

Quote:

-----Original Message-----
HI:
does anyone know it this can be done ?
if so, can you please share the basics and maybe some
sample code

((i am also interested in executing a DTS package from
ACCESS'97))

thanks

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Executing DTS packages from SQL SRVR 7.0 Stored Proc

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Executing DTS packages from SQL SRVR 7.0 Stored Proc - 10-05-2003 , 07:43 PM

Re: Executing DTS packages from SQL SRVR 7.0 Stored Proc - 10-06-2003 , 12:17 AM

Executing DTS packages from SQL SRVR 7.0 Stored Proc - 10-06-2003 , 12:22 AM