WOW, that was it.  I wasn't aware that the globalvariables were case sensitive.  It is always the simple things that cause the biggest problems.

Thanks so much for all your help.

That didn't work either.  If I set the globalvariable values in properties of the DTS package the package works but uses the values I put in the properties page.  If...

I tried that but the DTS package errors out now when trying to run because the globalvariables values are not coming in.