RE: Running a Package

Tech-Archive recommends: Fix windows errors by optimizing your registry

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:

> 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
>
>
>
.

Relevant Pages

  • RE: ELSE UPDATE
    ... I am reviewing your post and our MVP provide some information and some ... place to check when you execute your T-SQL, ...
    (microsoft.public.sqlserver.programming)
  • Re: execute a t-sql code from outer files
    ... Executing the T-SQL within a file can be done with T-SQL, ... computer language over T-SQL, but if you just want to read those files ... and execute the T-SQL without changing the files, ... But you would probably find the programming language approach to ...
    (comp.databases.ms-sqlserver)
  • Re: SqlCommand.ExecuteReader takes too much time
    ... Are you starting your "T-SQL", whatever you mean with that as the DataReader uses as well T-SQL, from the same machine as your DataReader? ... "Achim Domma" schreef in bericht ... If I execute a "select * from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Execute SSIS Package
    ... There is no native T-SQL command to execute a package, ... I don't think executing packages from T-SQL is the best idea. ... > in SQL Server 2005 without having to go to xp_cmdshell and run DTExec? ...
    (microsoft.public.sqlserver.dts)
  • Re: How to retrieve a returned SQL function value?
    ... You can use SqlCommand to execute a T-SQL to return the value. ... > Hello, friends, ... > There is a function in SQL Server 2000, ...
    (microsoft.public.dotnet.framework.adonet)