Passing global variable to execute package task

[csunix]

I need to pass selected details for a number of sites from a SQL table to a text file for each site. The text file is created at the time of running and its name is partly made up from the contents of a field in my table.
I am using an execute package tasks to select the required details with a dynamic properties task to assign to text file name. I am want to pass the value to be used in the filename in a global variable from the parent package to the child package but I can't get it into the global variable of the execute package task
I am very new to DTS and SQL in general so any advice in the simplest of language would be appreciated!

 

[btturner]

This involves several steps.. which is well documented (samples included) in Chapter 15 of the "SQL Server 2000 DTS" text (WROX) by Chaffin, Knight, & Robinson.

You'll need to declare Inner or Outer Global variables then prime them via a SELECT statement (EXEC SQL TASK) using imbedded question marks (?,?,?) representing relative positions for your declared variables.

I wish I could be more specific - Chapter 15 is excellent for your needs