Home Forums Data Warehousing Integration Services Moving zip files RE: Moving zip files

  • February 6, 2018 at 6:16 am

    #1978683

    Phil Parkin - Tuesday, February 6, 2018 5:50 AM

    Steve has got it right, despite his 'not much of an SSIS guy' disclaimer ðŸ™‚

    Use a FOREACH loop to process the file, even though you know that there will be only one zip file present. Why? Because the FEL does the work of mapping the exact file name to a variable of your choosing (which also means that you can make your unzip command more refined).

    Seconded. Very easy to setup and lots of guides online how to do this with any file extension. Matter of fact, I don't think I've ever not used one even when I know it's just one file. Just in case it becomes more than one, I don't have to go back to it.

    Outside of that, I've actually used script tasks for unzipping with Python. Seemed easier to do those types of operations in another scripting language like Python or so that would unzip, rename, and so forth.