Using SQL 2000, I need to:
* Get data via a stored procedure
* Write data to a text file that has a unique name ("Filename + date".txt)
* FTP this text file to a remote server (ftp://ip.add.res.s/Reports
) using User ID and Password
I understand that could be run via T-SQL from a command shell or via DTS. Please give me an example of how to complete one way or the other.