O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Running external applications: Execute Process Task

One of the handiest tasks in SSIS Control Flow is the Execute Process Task. With this task we can run any other application that has an executable file. The only thing to consider is that the executable file should be run in silent mode because SSIS isn't made for interaction with users. In this recipe, we compress and decompress some files within this task with the help of 7-Zip.

Getting ready

  1. Complete and finish the Sending and receiving files through FTP: FTP Task recipe and use the downloaded text files as input for this recipe. Those files should be at C:\SSIS\Ch02_Control Flow Tasks\R03_FTP Task\LocalFolder.
  2. Download and install 7-Zip from http://www.7zip.com.
  3. Create a new empty directory for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required