Calling a DTS package within SQL Server Query Analyzer

#1

Hi,

Is it possible to call a DTS package from SQL Server
Analyzer??

If so, what is the syntax?

Thanks,
Abby

#2

There is no direct SQL command, but you can use xp_cmdshell to call DTSRUN
or you can use the OLE stored procedures to manipulate the object model.

Execute a package from T-SQL
(http://www.sqldts.com/default.aspx?210)

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

"Abegail S. Aquino" <aaquino2 (AT) vissg (DOT) jnj.com> wrote

Quote:

Hi,

Is it possible to call a DTS package from SQL Server
Analyzer??

If so, what is the syntax?

Thanks,
Abby

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

Calling a DTS package within SQL Server Query Analyzer

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

Calling a DTS package within SQL Server Query Analyzer - 10-09-2003 , 01:17 AM

Re: Calling a DTS package within SQL Server Query Analyzer - 10-09-2003 , 04:48 AM