DTS: Execute Process Task & Parameters

• Arun NS

  SSC Journeyman

  Points: 82

  More actions

  August 26, 2004 at 4:36 am

  #520671

  You can also do the below instead of using dynamic property.

  1. Create a ActiveX script before the execute process task

  2. Use the below code to change the parameter

   Dim oPackage

   Dim oCustomTask

   Set oPackage = DTSGlobalVariables.Parent

   

   Set oCustomTask = oPackage.Tasks("Execute Task Name").CustomTask

   oCustomTask.ProcessCommandLine  = "Command" + " My Param"

   

  3. On sucess of Activex script, go to the execute process task.

• kkjain8

  Newbie

  Points: 3

  More actions

  May 4, 2009 at 6:34 am

  #988056

  Hi,

  I am using SQL Server 2008/2005. I would like to pass argument value in ExecuteProcessTask through the variable. How Can i achieve it?

  Thanks & Regards,

  K. K. Jain