Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: delete records in the destination file in SSIS

    How do I delete records in the destination file in SSIS using BI Development
    Studio? Thanks.

  2. #2
    Join Date
    Nov 2006
    Posts
    43
    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?

  3. #3
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    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.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  4. #4
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    truncate table [table]. for sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •