I have a store procedure to create a couple of talbe an insert data to tables like below sample.
I want to export data from these two table to my excel file, the table a on sheet1 and table b on sheet2. I am really new to SSIS. When the package runs again, it should truncate the two table first. Could you provide me steps?
creteat table a
insert table a
creteat table b
insert table b