remotely Upload a text file to SQL server database

[alander]

hi, i got a text delimited file that i want to do upload to a SQL server database remotely using a vb.net application via FTP, i have searched alot of places but I am unable to see any light regarding this.. can anyone point me to the right direction??

It would be nice if anyone could provide some examples

Any help will be appreciated

 

[giadich]

a couple of suggestions:

1. Run an ftp server, write an app to poll and process files in the ftp folder.

2. Connect to sql with vb.net app, read the file, insert data in sql.

3. Write your own vb.net server to accept file transfer and process the data file on the server and the client to send the file.