Hello Everyone,

I like to know if a DTS package could be executed from
within a stored procedure.
I looked at the SQL Server Books Online and did not find
any help.

Thanks,

--Mitra

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"
<mitra928 (AT) hotmail (DOT) com> wrote:

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


"mitra fatolahi" <mitra928 (AT) hotmail (DOT) com> wrote

On Tue, 13 Apr 2004 10:21:41 -0700, "mitra fatolahi"
<mitra928 (AT) hotmail (DOT) com> wrote:

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

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
CanadaDBA (AT) yahoo (DOT) ca