Dear Eric, I need to set a system or strategies that will fulfills the needs of constantly loading a database from another (over LAN) using FTP technology. I'm wondering if you can advise on how to go about that.

Thanks for your help.

-- Anonymous, November 06, 2000

Answers

Jennifer,

Check out the File Transfer Protocol task provide by Data Transformation Services.

Hope this helps,

Eric

-- Anonymous, November 08, 2000

Just Create Txt File like this

Named : GetFileFromFTP.txt open IPAddress username Password get testtxt.txt bye

then create batch file to call this txt file like this

Named:FILEFTP.bat d: cd\ del d:\testtxt.txt ftp -s:GetFilefromFTP.txt

u just call this bat file from Xp_cmdshell u' ll get the file from the ftp. this can also be automated by using batch file with paramters ThankZ

-- Anonymous, July 27, 2004