Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    chicago
    Posts
    3

    Angry Unanswered: DTS task properties and global variables

    Hey all,
    I have a stored procedure, which need one variable as parameter. I am trying to call this stored procedure from my DTS Task and my parameter is defined as the Global Variable in DTS. here is the SP call within my DTS Task

    declare @id int
    select @id = DTSGlobalVariables('ClientId' ).value
    exec sp_Update_DayPart @ClientId= @id


    it gives me an error that DTSGlobalVariables function not defined. In this case how can i pass the value of Client Id which is my global variable to my SP.

    Thanks in Advance

  2. #2
    Join Date
    Mar 2004
    Location
    chicago
    Posts
    3
    never mind, found out the way to pass the globalvariable to my SP from my DTS task

    if interested read on :
    SElect Execute SQL Task

    within that , SQL statement :
    exec sp_Update_DayPart ?

    and then click on parameter and select the global variable u want to pass to the stored procedure.


    -- Vikram

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •