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

[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

[Ken Tucker [MVP]]

Hi,

http://support.microsoft.com/default...b;en-us;832679

Ken
--------------
"Rasta" <ab*****@netgate.net> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
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

[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
*** Sent via Developersdex http://www.developersdex.com ***

[Tom Shelton]

On 2005-07-28, alien51 roswell <ab*****@netgate.net> wrote:

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
*** Sent via Developersdex http://www.developersdex.com ***

Put your app in the task scheduler?

--
Tom Shelton [MVP]