vb.net code to download file from ftp server to location on database server

R

Rasta

Hi,

I need to write a vb.net program to look for and download a file from an ftp
server. The file needs to be downloaded to the same server that the .net
program will run from. Next I need to create a dts package on SQL server to
run this program at a set time each day. Does anyone have some code that
does this type of download. And, can a dts package be set up on SQL to run a
..net program? Does the program need to reside on the same server as the SQL
database?

Thanks,
Rasta
 
K

Ken Tucker [MVP]

Hi,

http://support.microsoft.com/default.aspx?scid=kb;en-us;832679

Ken
--------------
Hi,

I need to write a vb.net program to look for and download a file from an ftp
server. The file needs to be downloaded to the same server that the .net
program will run from. Next I need to create a dts package on SQL server to
run this program at a set time each day. Does anyone have some code that
does this type of download. And, can a dts package be set up on SQL to run a
..net program? Does the program need to reside on the same server as the SQL
database?

Thanks,
Rasta
 
A

alien51 roswell

Hi,

Thanks for the link - that code worked like a charm! My remaining
question is, how can I schedule this vb.net code to run at a specific
time each day? Can this be done through SQL Server or is there a
better/alternate way?

Thanks again
 
T

Tom Shelton

Hi,

Thanks for the link - that code worked like a charm! My remaining
question is, how can I schedule this vb.net code to run at a specific
time each day? Can this be done through SQL Server or is there a
better/alternate way?

Thanks again

Put your app in the task scheduler?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top