Hey Kevin :)
Excellent suggestions, but unfortunately I must stay within the SQL Server 2005 BI Reporting tools in SSIS. The reporting tool will run a stored proc I have sitting on a server and I can deliver a report file via email. I need to understand how to ftp the report via ftp, through the scheduling/subscription tool. The BOL says it’s simple but it does not explain how to do it.
Jon