I dont understand, how this tasks need to be done in SSIS.
The table is created in the database. I setup a connection to database. i had weekly running ssis package in which, data is moving from SQL to Excel File. I had a couple of tasks in control flow:
Execute process task, in which executable command file is present. Here last 5 copies of data is stored.
DataFlow Task: Used for moving data from SQL to Excel Sheet.
Now i need to insert couple of commands in this package.
Truncating the table in a database (truncate command)& Inserting fresh data into the table(Insert Command), so that this fresh data moves into excel sheet
Can u please help me out with the above tasks.