SQL Server Performance

delete records in the destination file in SSIS

Discussion in 'SQL Server 2005 Integration Services' started by supernova122, Apr 9, 2007.

  1. supernova122 New Member

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

    Do you mean after importing data from flat file into table, you want to clear the file records, then you could delete the file instead.
  3. dineshasanka Moderator

    what is your destination. DB/Excel/Texr?

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. supernova122 New Member

    I mean before I export to the DB file and this job is running daily.
  5. dineshasanka Moderator

    U can do this by using a sql task. execute delete statment in the sql task

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  6. Pharoah_DBA New Member

    Instead of using the delete statement, possibly use Truncate due to logging...

    just my 2 cents
  7. supernova122 New Member

    In fact, it is DBase file.

Share This Page