best way?

[farshad]

my intention is to check a folder every so often and take the .txt files one by one and transfer the data in the text files into a sql server database table.
Should I use DTS within vb.net or some other means?
Thanks

 

[mutant]

You should look into the FileSystemWatcher component, its in the toolbox of VS under components tab. That components monitors the file system and raises events when something happens to the directory or files.

 

[farshad]

thanks for the tip, but as far as the data transfer, should I use DTS or some other means?

 

[JABE]

If its a simple data transfer, then DTS may be an overkill and will be just another point of failure. You can use BULK INSERT to insert the data into your tables.