July 19, 2014 at 10:34 am
When I use the File Enumerator Property: FileNameRetrieval instead of FileSpec for the expression "*"+@[User::datePart]+".txt.zip".....
it finally maps this expression to the zippedFile variable and loops!!!!!! yay.
but.
now...after iterating through all the zipped files having 2014-06-20 timestamp and unzipping them nicely..... the Execute Process Task is not incrementing to the 2014-06-21 datePart. It wants to forever loop over the 2014-06-20 date stamped files.
perhaps this is where I need to put the Foreach Loop Container inside another Foreach Loop container...
July 19, 2014 at 2:56 pm
Hi KoldCoffee,
probably you need to update your TimeCol table, set IsProcessed column to 1 for datePart 2014-06-20.
--Quote me
October 9, 2014 at 4:06 pm
I am wondering if you could not eliminate the nested looping by only using the one loop to iterate through the dates and then somehow build an expression pertaining to the command of the execute process task. For instance with an old fashioned DOS command I can copy all (example) *2014-06-20.txt files with one command. I don't need any looping mechanism there. Or can you only unzip one file at a time with your external executable?
----------------------------------------------------
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply