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.
    supernova122, Apr 9, 2007
    #2

  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.
    ranjitjain, Apr 9, 2007
    #2

  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/
    dineshasanka, Apr 10, 2007
    #2

  4. supernova122 New Member

    I mean before I export to the DB file and this job is running daily.
    supernova122, Apr 10, 2007
    #2

  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/
    dineshasanka, Apr 10, 2007
    #2

  6. Pharoah_DBA New Member

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

    just my 2 cents
    Pharoah_DBA, Apr 12, 2007
    #2

  7. supernova122 New Member

    In fact, it is DBase file.
    supernova122, Apr 12, 2007
    #2

Share This Page