var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to copy txt files from FTP?
I want setup a scheduled job to copy txt files from FTP to local hard drive. How to open FTP and copy files from SQL Server Query Analyzer?
1) Create a DTS package to do the copy (and probably the processing too).
2) Create a SQL Server Agent Job to execute the DTS package
3) Call sp_start_job to make it go.
else u will have to call a FTP script file, that will do the download, using shell as
and the script file (FTPScriptFile.txt) should contain
xp_cmdshell 'ftp -s:c:\FTPScriptFile.txt'
or File Transfer Protocol task in DTS.
That sounds like a great idea to me.
Originally Posted by PMASchmed
Personally I have always used BAT or VBS files...