Thank you for the suggestions - However, my VB skills are limited - I was trying to use DTS to create the global variable.  I understand how to set the variables - What I am still confused on is how to set the value of the variable when it is constantly changing.

According the the DTS  you have establish the file path(hard coded) - I need to use Lookup of somekind - I have a Temp table that will store the value.

Also, if I change the code behind a DTS how do a view  it back in DTS?

Karen