Running a Package from Stored Procedure

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Yash (anonymous_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Mon, 19 Jul 2004 23:46:19 -0700

Hi,
Go thru this article

http://www.databasejournal.com/features/mssql/article.php/1
0894_1459181_1

Cheers,
Yash
>-----Original Message-----
>I would like to run a package while passing it a variable
from a stored procedure. The xp_cmdShell method isn't
working because dtsrun is working from the command line.
Is there another way?
>.
>

Relevant Pages

  • Running a Package from Stored Procedure
    ... I would like to run a package while passing it a variable from a stored procedure. ... The xp_cmdShell method isn't working because dtsrun is working from the command line. ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Procedures not found
    ... Well because you are passing an active connection to the DB that contains ... the stored procedure you only have to set the command text to be the actual ... What you was doing was setting the command text to "EXEC server.db.sp ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Execute DTS Package from a SP
    ... DTSRun is a command line utility, so you can not execute as if it was ... If you have to run the package from the ... stored procedure, then you'll have to use xp_cmdshell. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to run a DTS package or Stored Procedure from SQL command line
    ... you can use the DTSRUN command to execute the package, ... run the stored procedure. ... > I need to run DTS packages and SPs from SQL command line (WIN command ...
    (microsoft.public.sqlserver.programming)
  • Re: Stripping Out Quotes For Database Storage
    ... > Sarcasm met with sarcasm. ... > understand the difference between adChar and adWChar. ... But if I'm passing a name like 'Jones', why does it matter which one it is? ... But if it's a stored procedure that returns data, ...
    (microsoft.public.inetserver.asp.general)