Archive files in ssis

  • I would like to create a command line tools in SSIS which can be used to archive files.

    I have 6 files in a dir and i like to zip them up and them move them to an archive dir.

  • Have you tried using the File System task? May not be flexible enough but...

    Or, you could use an Execute SQL task. The drawback with this is you have to have xp_cmdshell enabled. Although, your script could include a line to enable it, run your process then disable it when finished.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply