sql server dts: executing DTS package from Stored Procedure -- sql server dts

Re: executing DTS package from Stored Procedure

Sue Hoegemeier
4/13/2004 11:44:03 AM

The following link will explain a couple of options on
executing the package using T-SQL:
Execute a package from T-SQL
http://www.sqldts.com/default.aspx?210

-Sue

On Tue, 13 Apr 2004 10:21:41 -0700, "mitra fatolahi"
[quoted text, click to view]

Re: executing DTS package from Stored Procedure

Allan Mitchell
4/13/2004 6:44:26 PM

It most certainly can be yes

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

--
--

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

[quoted text, click to view]

RE: executing DTS package from Stored Procedure

Farhad Raeisi
4/13/2004 7:16:03 PM

You need to run the DTS using dtsrun command. In your stored procedure use the following

exec master.dbo.xp_cmdshell 'dtsrun /S <servername> /E /N dts_name

which <servername> is your server name or IP address and dts_name is your DTS package name. I hope this solve your problem

Farha

Re: executing DTS package from Stored Procedure

DTJ
4/13/2004 11:42:44 PM

On Tue, 13 Apr 2004 10:21:41 -0700, "mitra fatolahi"
[quoted text, click to view]

If you schedule the package, you can. You actually run the scheduled

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.