Ok Base scenario i have two reports that are called from a web service i want to then put these reports into one excel spreadsheet (e.g.Sheet1 sheet2) using a SSIS package is this possible? If so how ?
-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: Which is the most hair-raising South African mountain pass you've driven?
two reports into one excel SSIS
- Thread starter InSanity
- Start date
looks like you'd need to create two data flows - one to read from each source,
In each Data Flow
Create the Source object
Link it to an Excel Destination.
in the Excel Destination - select the spreadsheet, and then select the worksheet.
Make sure the dataflows run in series, else you might lock the sheet.
In each Data Flow
Create the Source object
Link it to an Excel Destination.
in the Excel Destination - select the spreadsheet, and then select the worksheet.
Make sure the dataflows run in series, else you might lock the sheet.