I have an updated question, since I dont think assigning Global Variables under DTS packages is intuitive at all. I now have a ext file source connection callled 'Conect1' with a hardcoded txt file. I would like this file to be dynamically changed in accordance with the date. He'res what I've done so far
1) Created a global variable called 'Filename' (works)
2)Created a vbscript which updates the filename global variable to filename_NowDate.txt (works)
3)Went into Dynamic Properties Task then clicked ->ADD -->Connections --'Connect1'
Now in the Datasource properties of the Connect1 there's currently a directory of the hardcoded txt file
which needs to get the value of the 'Filename' Global variable
HOW IS THIS DONE, I'm stuck?
Start Free Trial
