September 22, 2010 at 6:23 am
Hi Guys
I am having a problem setting up a process task that unzips a file. I can get the process to work if I put the path in the arguments field.
What I want is to get the arguments to obtain the file location from a text file, this method was used for sftp,but I cant seem to get it to work for 7-Zip.
in the executable file i put the location of the 7-Zip executable file
in the arguments I want it to read from a text file on c:|
in the working directory I put the location the file is to unzipped to.
In the text file I put "x C:\source.zip c:\destination.csv"
Could anybody give me an idea what I should put in the arguments so it read the file paths from the text file.
Cheers;-)
September 22, 2010 at 8:18 am
I think you would want to set the value of the process task arguments dynamically by using a package configuration. Is there a reason that these arguments need to come from a plain text file as opposed to a package configuration.? If you saved the package configuration as XML, you could edit that, or if you save in a sql table you can update it via SQL query.
If you must use your text file, one approach would be to use a script task to read in the text file and assign the contents to a variable, then use the variable in an expression to set the value of the process task arguments.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply