December 10, 2015 at 11:33 am
I have a third party application that generates a dynamically created zip file in the following format (<FileName>.csv_2015-12-09_21-17-47.zip) I want a expression or task that will extract this file in the same location, but each time this file is generated it has a different timestamp. How can I create an expression to do a "Like" each time it is put in this folder. The rest of my process will move it out of the folder so each day only one file will be generated. I have experimented with the Extract Zip File task, which does work if I can get the file name correct and constant. I have also experimented with the For Each Container but have not found the correct solution.
Any ideas will be appreciated. Thank You!
December 11, 2015 at 10:17 am
I have experimented with the Extract Zip File task
As far as I know, there is no standard SSIS task which does this. Are you using third-party tools?
You should be able to use the foreach loop container to get the file name pushed into a variable at run time. Once it's there, the task becomes straightforward.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply