what is best way to automate loading text files with different names?

what is best way to automate loading text files with different names?

Post by Stephane Via » Fri, 19 Jan 2001 22:12:35



what is best way to automate loading text files with different names?

Thanks,

Stephane

 
 
 

what is best way to automate loading text files with different names?

Post by Darren Gree » Sun, 21 Jan 2001 19:44:49




Quote:

>what is best way to automate loading text files with different names?

>Thanks,

>Stephane

If the files are of the same structure then this is relatively easy, as
you can change the file name of a text file connection at run-time.
There are two methods explained on my site for importing all files in a
directory.

--
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