Home > SSIS Best Practices > SSIS – Create Excel Data File (2)

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

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: