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 |
|
BillyCrystal
Starting Member
3 Posts |
 Posted - 2004-10-12 : 10:21:31
|
| Please bear with me, as I am a newby at this....I am attempting to import several csv files into a staging database for processing, but I need to record and compare the date stamp of the import files being supplied prior to importing them. Any suggestions? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-12 : 11:25:05
|
| Seehttp://www.nigelrivett.net/ImportTextFiles.htmlIt will import text files and you have the filename (you can get the date the file was created by changing the dir command) in the SP to do whatever you wish with.==========================================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. |
 |
|
|
BillyCrystal
Starting Member
3 Posts |
Posted - 2004-10-12 : 13:10:23
|
| Your response was very interesting, though missed the mark due to a poor explaination on my behalf.I need the date/time stamp from the bcp1.txt and bcp2.txt in your example as would be shown in a C:/Dir listing. |
|
|
|
BillyCrystal
Starting Member
3 Posts |
Posted - 2004-10-12 : 13:15:18
|
| Don't worry, I have finally caught onto what you said......doooooh |
|
|
|
|
|
|
Getting csv import file date