Exporting data to Excel, but to named spreadsheet(s).  These notes are taken from an exercise using SSIS 2008R2. Create the Data Flow and export data (in required format) to an Excel Destination (creating an Excel Connection Manager in the process).  … Continue reading →