Running a Package from Stored Procedure

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

From: TomTait747 (TomTait747_at_discussions.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 15:26:01 -0700

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. ... working because dtsrun is working from the command line. ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling Problem - Duplicate Attachments
    ... So how is the package requesting the Excel File? ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun: Executing... ...
    (microsoft.public.sqlserver.dts)
  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS ActiveX Scripting
    ... DTSRun: Executing... ... Error string: ActiveX Scripting ... Run Time Error during the execution of the script. ... Package Help file: sqldts80.hlp Help ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSrun
    ... And the package worked. ... it seems that> dtsrun generates a string that does not work but I am unsure why at this> juncture. ... Any DTS package saved with an owner password>> fails ...
    (microsoft.public.sqlserver.dts)