HOW T0 PASS AN INPUT AND OUTPUT (GLOBAL PARAMATERS) TO stored proc

• nogardoel

  SSC Eights!

  Points: 915

  More actions

  October 24, 2006 at 7:33 am

  #170844

  Hi,

       I am a new bee and here is my situation, i have a stored proceedure which takes in an input and an output. This stored procedure is called in a EXECUTE SQL TASK IN one of my DTS PACKAGES. SO now i am not sure as to how to assign these 2 global variables already declared in the DTS package to the stored proceedure when i try to execute it in EXECUTE SQL TASK

  create PROC dbo.sp_Match_Name_FILE

   @FILENAME VARCHAR(5),

   @I INT OUTPUT

  AS

  SELECT @I = CASE WHEN ID_TOWN = @FILENAME THEN 1 ELSE 0 END FROM HAVA_IMPORT..IMPORT GROUP BY ID_TOWN

  GO

• tzonekev

  Mr or Mrs. 500

  Points: 593

  More actions

  October 25, 2006 at 5:15 am

  #667806

  A good article:

  http://www.sqldts.com/default.aspx?234