var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: delete records in the destination file in SSIS
How do I delete records in the destination file in SSIS using BI Development
I mean I am running a daily task and I want to delete the records in destination DB or xls file before I export to this file. How can I do the delete task?
Execute SQL Task for tables.
For Excel, I honestly don't know, but you might end up using a Script Task, where you use the Excel Object Model to empty the excel sheet.
truncate table [table]. for sql