Hi i'm new to DTS and need to be able to import a text file into a table each day.
The main problem I have is the file is datestamped so the name of the file changes each day.
Today it would be called file20070419.txt tomorrow it would be file20070420.txt. When I select a text file as a source I have to pick a valid file ? how can I get round this ?
DTS or SSIS?If DTS, you may want to seek help in the DTS group, http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg
