Need T-SQL 'example' on how to FTP text file.
Posted on 2008-10-30
I need a code example for:
Using T-SQL (SQL 2000), I need to use an existing procedure to send the data results to a remote FTP folder as a .csv file with pipe delimiters. I can modify the existig procedure or call it with another procedure.
I have already explored this with DTS ... and am looking for a code example of the above that I can cut/paste/modify to get this request off my desk. (I'll go back to some great DTS examples later.)