Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
v_kash
Starting Member
45 Posts |
 Posted - 2011-09-08 : 14:46:14
|
| OK. I've seen some articles (on using execute process task to unzip a file), but am still having issues. Eventually, I'd like to unzip a file, and then take those CSV files and load them into a table, and then archive the ZIP FILE. I am new to SSIS. I know how to load the files. I have no clue on how to unzip. For my scenario (which all i want to do is UNZIP the file):My zipfile is in the following path:C:\ZIP (the name of the zip file is TR110907.ZIP)I brought in the EXECUTE PROCESS TASK and in the EXECUTABLE - i put in this - C:\Program Files\WinZip\WinZip32.exeWhat do i need to put in the 'working directory? Also, is there anythign i need to put in arguments to get this to work?? I just want to unzip the file. I appreciate any help! Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 15:21:06
|
| I use winrar for this, but if there is a command like interface for winzip, then you'll need to use that. |
 |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2011-09-08 : 15:46:16
|
| Actually, all i had to do was put this in the arguments --e C:\ZIP\TR110907.ZIPthat extracts the zip file. thanks |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2011-09-08 : 16:51:51
|
| Ok. 1 more question. Right now using -e C:\ZIP\TR110907.ZIPin the arguments works. However, the name of that file is not static. Tomorrow, for example, the zip file name will be TR120907.ZIP. How would I take this in account? I imagine, a variable, but could not get that to work! Any ideas? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 16:58:34
|
| *.zip should work |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2011-09-08 : 17:14:23
|
| -e C:\ZIP\*.zipi tried that (forgot to mention that earlier), but it doesn't like it. |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2011-09-09 : 13:44:51
|
| anybody have any suggestions? |
|
|
|
|
|
|
|
|
UNZIP FILE