Results 1 to 4 of 4
  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: using SSIS Package to delete source files.

    hi guys,
    is it possible to delete a source file(*.txt) when a SSIS package is done with it?

  2. #2
    Join Date
    Aug 2008
    Posts
    147
    yes . One method is the File System Task
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Its generally a better idea to move the source file to an archive folder, rather than delete it.
    The file system task can be used for the same operation.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    May 2010
    Posts
    52
    thank you guys. i will look at the file system. thanks a lot

Posting Permissions

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