question

ojmp2001ojmp2001-0652 avatar image
0 Votes"
ojmp2001ojmp2001-0652 asked CarrinWu-MSFT commented

SSIS Excel output from SP with a Temp table

I have an SSIS pkg that goes through the following steps:
1. Pull data from Server A And Server B
2. Put the data in Server C
3. Server C has a Stored procedure that combines and compares the data from Server A and Server B
4. Output in server C from step 3 is in a temp table That I would like to put in an excel Sheet and email it to users.

How do I do step 4?
I am using VS2017. There are seral columns in the output



sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ojmp2001ojmp2001-0652, we have not get a reply from you. Could below answer help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @ojmp2001ojmp2001-0652,

Thanks for your posting.

  1. Install Microsoft Access Database Engine to make sure you could connect to excel successfully. The connectivity components for Excel are not installed by default.

  2. Control Flow task 1 - Data Flow:
    OLEDB Source. Choose the source table/view/use a query...
    Excel destination.

  3. Control Flow task 2 - Send Mail Task. Attach the above generated Excel.

For more information, please refer to below links:
Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS)
Send Mail Task
MSBI - SSIS - Email Excel File Report - Part-129


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.