what is best way to automate loading text files with different names?
Thanks,
Stephane
by Stephane Via » Fri, 19 Jan 2001 22:12:35
what is best way to automate loading text files with different names?
Thanks,
Stephane
by Darren Gree » Sun, 21 Jan 2001 19:44:49
If the files are of the same structure then this is relatively easy, asQuote:>what is best way to automate loading text files with different names?
>Thanks,
>Stephane
--
Darren Green
SQL/DTS - http://www.swynk.com/friends/green/
1. Source file a text file with different names
I need to import data from a text file into SQL Server.
These files get generated by the HR and are dumped on a n/w drive in a
folder. The only problem is these files are different every day and have a
time attached to the filename.
eg: fileA11102001.txt,
fileA10102002.txt...
And thats fine.. But since i would upload the file daily, how can i get the
latest from these files in the folder automatically ?
ANy suggestions would be appreciated
Thanks
2. KB 320407
3. Please give opinions on different ways to setup disks for best performance under SQL
4. Pdox7 Runtime - Lookup Feature
5. SQLLoad (or other ways) to load large text fields
6. Wav sound on SQL Server Installation
7. Best ways to store Text of indeterminate length
8. Scan Density
9. Different SQL Server's Approaching View in different ways
10. loading a 400K text file into a text field in SQL
11. Loading a Text File into a TEXT or nTEXT Column
12. dump and load with different named segments?
13. Loading database under a different name