Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    9

    Unhappy Unanswered: Global Variables

    Hello,

    Im having a little problem(i hope) with global variables.

    Im working with the DTS of the SQL SERVER 2000! Does someone knows how can i load global variables using an SQL Task!???

    Thank you all!!

    Kind Regards,
    LULU

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    in package properties, add global variable x with correct type
    create execute sql task , select the value you want to
    populate your global variable,click on parameters in the exec sql task properties,
    click on output parameters,set type (row,rowset), map the output to the correct global variable.
    To use the variable, in a exec sql task, click on parameters,
    get your global variable, map it to parameter 1
    then in query use a ? to reference the global variable.
    -des

  3. #3
    Join Date
    Jun 2003
    Posts
    9
    Originally posted by DesmondX
    in package properties, add global variable x with correct type
    create execute sql task , select the value you want to
    populate your global variable,click on parameters in the exec sql task properties,
    click on output parameters,set type (row,rowset), map the output to the correct global variable.
    To use the variable, in a exec sql task, click on parameters,
    get your global variable, map it to parameter 1
    then in query use a ? to reference the global variable.
    -des
    Thanks..... DESMONDX

Posting Permissions

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