No file to extrat erro while trying to unzip with SSIS

Question

I  have some files with .rar extension and I am trying to unzip them with "Execute process task" in SSIS. When I try to do it from SSIS then it gives me following error:

" No files to extract" but when I directly try to extract files then they are extracted fine Iam not sure what is wrong.

Any ideas?

Answer 1

test your package outside of BIDS. execute it via the command line and turn on verbose messaging. Odds are that SSIS isn't looking in the right place, but the only way to be sure is to see exactly what's happening outside of the GUI.

---

Garth H MCTS: SQL 2008 BI http://bitinkering.spaces.live.com/

Answer 2

I am not sure how to test the package outside BIDS????

Answer 3

1. Create deployment manifest by building the solution
2. Deploy the package on to SQL server or filesystem.
3. If SQL Server, login to IS via SSMS and go to Stored packages->MSDN-><Package name> and execute package
4. IF File system, double click and execute the package.


Also, Check whether you have configured the path correctly.

---

Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.

Answer 4

I  have some files with .rar extension and I am trying to unzip them with "Execute process task" in SSIS. When I try to do it from SSIS then it gives me following error:

" No files to extract" but when I directly try to extract files then they are extracted fine Iam not sure what is wrong.

HI Kunal
could u share how are u un zipping files in Execute process task ???
I am asking this because probably u are missing out something ating the execute process task ... ideally speaking what ever task u create in bids u should be able to ruin bids .....

BTW what do u mean by : "when I directly try to extract files then they are extracted fine "
what i guess is probably the path u are setting for the files to be unzipped is not seetting up correctly ..

** also please check the size of file to be zipped / unzip as there is limit constraint for the file size..