Changing Destination name

  • 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

  • You will need an Active X script or a Dynamic Properties Script that can alter the connection. Dynamic Properties is the easiest.

    Steve Jones

    steve@dkranch.net

  • 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