Hi,
Are there any T-SQL command for running a package or I must necessarily use
dtsrun.exe within my SPs?
Thanks in advance,
Leila

You can try using xp_cmdshell to execute dtsrun.exe from you T-SQL

for example:

exec master.dbo.xp_cmdshell 'dtsrun /S"(local)" /N"<package_name>" /A
"<global_Variable1>":"8"="<global_variable1_value> " /E'

Hope this helps

Cheers
Vikram

"Leila" wrote:

Have a look here

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Leila" <Leilas (AT) hotpop (DOT) com> wrote