Is it possable to update a Global variable in another DTS package that is to
run later from a stored procedure that is running in a package now

not really.

The values in the package will be those from design time unless you save back the package after altering the variables.

The thing to do is log the result (what you want the package running later to use) to a storage location (SQL Server table, ini
fille etc etc) and have the package read it from there

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


[quoted text, click to view]

You might find it better to save the values from the sp rather than try to
update the package.

You can write the values to a table which the dts package reads when it runs.
You could save the dtsrun command with the setting of the global variables
and use that to load the package.
If the package is run from a scheduled command then you can update that
dtsrun command to include the global variables.


[quoted text, click to view]