Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcdye
Starting Member
3 Posts |
 Posted - 2005-10-25 : 08:40:37
|
| I am trying to create a process that will import a tab delimited text file every night. The file name changes daily based on date format (mfe20050930.log, mfe20050931.log). I will be processing one day behind. I am not a programmer AT ALL, so please be specific so that I will understand. My hang up is the part of file name needing change and picking up the new name for the import process.1) A task to generate yesterday's date in the correct format.2) The import to dynamically read the generated filename.TIACD |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-25 : 14:11:31
|
| Or you can just impotr all files that are in the folder (with the file mask) and move them to an archive folder after the import.seehttp://www.mindsdoor.net/SQLTsql/ImportTextFiles.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-25 : 14:29:12
|
| Which presumably has the benefit that if you miss one for any reason ("Server was down at the time") it will get imported "next time"Kristen |
|
|
|
|
|
|
Import File that names changes daily