Using SQL 2000...

I have two DTS packages...

One package drives the other package by passing global varialbes to it (I
have no problem doing this). However, it appears that the global
variables simply disappear from time to time in the secong package, or no
longer stay "saved" in the dynamic properties control.

Is there a way to programatically initialize and set the variables /
properties using VBscript ?

For example...

I want to extract a SQL view to an Excel file that does not pre-exist...

Using VBScript intialize and set the path name (C:\Test\ABC) for the Excel
file and "Create the Table" for this file CREATE TABLE 'View1' ('A'
VarChar(10), 'B' VarChar(10)) ?

Thanks !