hi guys,
this is possibly a common one - apologies if so!
I have a number of stored procedures that produce report data that i need to get into the same excel file (multiple tabs/sheets)
Each proc results in a different table with different columns etc.
I remember with DTS there was a 'tool'/'object' that i used to drop and recreate the tables on each run - then you could point each sql query to the required tab/table.
How do you do this in SSIS - i have tried the drop table and create table statements (had to use an individual 'Execute SQL Task' for each of these) in control flow.
But then in data flow when i try to point a second OLE DB source to the Excel destination it errors saying that there are not enough available inputs etc.
any ideas where i am going wrong, and how to this?
cheers,
Dan
this is possibly a common one - apologies if so!
I have a number of stored procedures that produce report data that i need to get into the same excel file (multiple tabs/sheets)
Each proc results in a different table with different columns etc.
I remember with DTS there was a 'tool'/'object' that i used to drop and recreate the tables on each run - then you could point each sql query to the required tab/table.
How do you do this in SSIS - i have tried the drop table and create table statements (had to use an individual 'Execute SQL Task' for each of these) in control flow.
But then in data flow when i try to point a second OLE DB source to the Excel destination it errors saying that there are not enough available inputs etc.
any ideas where i am going wrong, and how to this?
cheers,
Dan