How do I delete records in the destination file in SSIS using BI Development
Studio? Thanks.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment