I am writing an SSIS package. I am fairly new to SSIS (2005 if that makes a difference). I have taken a course but they have never addressed this particular situation.
I have to:
1 - Create an Excel spreadsheet from a stored procedure
2 - Rename it to a date stamped file name
3 - Copy it to an FTP server
I have been able to accomplish #1 with the help of the Import/Export wizard, so now I have an Excel sheet with a fixed name. I can't get # 2 to work. I think I want to use a File System task to rename the file to the date stamped version and capture the name of the file in a variable so that I can use it in the FTP Task, but I can't figure out how to do this (or even if my approach is correct).