Is there any way to execute dts package from stored procedure? If there is, please specify how.

Thank you.

Here you go


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


"she" <she (AT) discussions (DOT) microsoft.com> wrote

--Declaring variabl
DECLARE @objdts in

--Creating objec
EXEC sp_OACreate 'DTS.Package', @objdts OUTPU

--Loading DTS storage file to objec
EXEC sp_OAMethod @objdts, 'LoadFromStorageFile', NULL, 'C:\mypackage.dts', '

EXEC sp_OAMethod @objdts, 'Execute


----- Allan Mitchell wrote: ----

Here you g


Execute a package from T-SQ
(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 communit
for SQL Server professionals - http://www.sqlpass.or


"she" <she (AT) discussions (DOT) microsoft.com> wrote in messag
news:137786F5-5583-4112-88DB-A6AEE12D6DB0 (AT) microsoft (DOT) com..