Rahul Singh
asked on
Export multiple sql tables into one Excel tab using SSIS
I am trying to show data in Excel from multiple blocks of sql queries.
There is a stored procedure which give results in the form of multiple tables after execution.
I have to show these tables as they are in a tab in Excel. All tables may have different columns names.
if the first table's data starts from cell A1 and ends at A4 then, after inserting a couple of blank rows, the second table's data must start from cell A7 or A8 and ends at A10 or A11 and so on ,all these different tables should be in same excel tab.
There is a stored procedure which give results in the form of multiple tables after execution.
I have to show these tables as they are in a tab in Excel. All tables may have different columns names.
if the first table's data starts from cell A1 and ends at A4 then, after inserting a couple of blank rows, the second table's data must start from cell A7 or A8 and ends at A10 or A11 and so on ,all these different tables should be in same excel tab.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.