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