I am using "Execute SQL Task" to execute the following statement:
Select top 1 companyid from file_locations where statusid=0
I want to pass the companyid as a parameter to a global variable in the
package.

How do I do this?
Please show an example.
Thank you

Gary

You already did the first step by opening the task window & putting your SQL
statement in the center pane.

In the same window:
- Click 'Parameters' Button
- Click 'Output Parameters' Tab
- Choose 'Row Value' Radio button
- From here, dropdown under 'Output Global Variables'
to choose a premade Global ==OR==
- Click 'Create Global Variables' to create a new one

Once the task has been run, the global variable is populated for your use.

Also, check this out for a host of other goodies:
http://www.sqldts.com

Thomas Bradshaw
MyWebGrocer.com
Data Integration Services


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

Thank you for your response.
That was what I was looking for.


"Thomas Bradshaw via SQLMonster.com" wrote: