Calling store procedure from a DTS Package.

• Ranjee

  Newbie

  Points: 9

  More actions

  January 30, 2002 at 12:03 pm

  #151658

  Hi,

  Could any one tell me the process to call a Stored Procedure from DTS package.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736078

  More actions

  January 30, 2002 at 12:30 pm

  #422886

  Use the Execute SQL task.

  Steve Jones

  steve@dkranch.net

• jwiner

  SSCrazy

  Points: 2241

  More actions

  January 30, 2002 at 1:06 pm

  #422888

  Depending what you want to do with the results of the stored proc, you can execute it in an ActiveX Script task as well.