February 22, 2002 at 2:28 am
I have a simple dts package, taking a textfile into SQL table, then outputting the results to Foxpro table for remote distrabution
the problem is that the original txt file name changes every day FILEMMDDYY, and the foxpro table should be the same FOXMMDDYY
can this be done without intervention
as i would like it to be a scheduled job to fire all on its own, as this happens 7 days a week at the same time every day
February 22, 2002 at 9:55 am
You will need an Active X script or a Dynamic Properties Script that can alter the connection. Dynamic Properties is the easiest.
Steve Jones
February 27, 2002 at 6:10 am
I had a similiar situation. Heres how I got around it.
Step 1. Using VBScript, rename the file.
Step 2. Set up the connection to look for the same filename referenced in step 1.
To this I also added in the VBScript to look for the file, if it wasn't there then my script object would fail. This allowed for not running the import.
Also, I would move the file to an archive folder in the VBScript object.
This solution seems to work pretty well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply