I've had problems setting and retaining global variables dynamically in DTS Package properties called from a SP. I now know my problem lies with 'saving the package' after the variables have been set.
Does anyone know how I can achieve this dynamically on/before completion of the package?
I am changing values for importing filenames and changing the destination table according to the value of those filenames.
Does anyone know how I can achieve this dynamically on/before completion of the package?
I am changing values for importing filenames and changing the destination table according to the value of those filenames.