In BOL there are extended DTS objects which include Execute SQL Task2. This allows updating of Global Variables. I don't know how to turn the extented DTS objects on. They do not show in the toolbox. How do I do this?
I am trying to pass a file name to all objects in DTS package that is retreived by a stored procedure. I am using Global Objects for this
Steve