Wednesday, April 7, 2010

SSIS - Create Excel Data File (2)

Step 4: Now create a detail sheet and load it with data from a SQL table.

image

image

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.

image

The SMTP Connection Manager is define here with the appropriate SMTP server name.

image

No comments:

Post a Comment