Move files

Question

Hi Guys,

 

  I have 13 Flat files in my folder. i want zip this 13 files and move to the another directory. i want unzip this 13 files again  .

plz let me know .

which is better way.

Answer 1

Scenario:

1- use a Execute process task to ZIP files with any zip program ( for example winrar, winzip , gzip,...)

2- use a File System Task to move zipped file to new location

3- use another Execute Process Task to UnZip that file.

 

let me know where you need more details ?

---

http://www.rad.pasfu.com

Answer 2

this is a sample of unzip file with execute process task:

http://www.sql-server-performance.com/faq/ssis_unzip_p1.aspx

---

http://www.rad.pasfu.com

Answer 3

how to move files check the blog you have to change a few small options to move it

the blog copies files http://plexussql.blogspot.com/2009/11/coping-files-in-ssis.html

---

Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s)

Answer 4

If you want the ZIP self-contained in SSIS, you might want to try one of the Zip Tasks listed here: SSIS Community Tasks and Components.

---

Talk to me now on