question

I need to setup an ssis package that does the following: 1.there is an sp with cross server joins, this sp inserts all the resultsets into two temp tables. I have then inserted from the two main temp tables into perm tables (Execute SQL task) 2.Then i join the two temp tables together in a view to query the date for one resultsets 3.Then i need to import the resultsets into an excel spreadsheet. 4.The spreadsheet filename must be created dynamically everytime the package is executed ie: ServerCentral 2012-06-22.xls, the date part being the dynamic part of the name. The rest is constant. Please assist. I've set up the package with: Execute SQL task for the sp Exec SQL task for the view to join the two tables for one resultset Data Flow task( OLEDB Source), (Data Conversion), (Excel Destination) E-mail task (needs to attach the spreadsheet and e-mail) daily Also setup a variable for the spreadsheet (XLFileRootDir)