Hello all Hope you are all well,
I have a slight problem as i need to import data from an Access database on a daily basis, Now this is not problem, the problem lies in that the database name changes daily.
This is good in a way because there will be no duplicate entries, but bad because the file names always change...
the format of the names are:
is there a way this can be done with a Script or do i need to do this within DTS as this needs to be schedualed to import yesterdays Data in today Etc