SSIS – Create Excel Data File (2)
Step 4: Now create a detail sheet and load it with data from a SQL table.
Now my Excel data file has been created with a summary and a detail sheet.
Step 5: Let’s also send the Excel file to users via email as an attachment.
The SMTP Connection Manager is define here with the appropriate SMTP server name.