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

Execution from a command-line utility

Execution of a package from SSMS is very easy and handy, but there are many cases where you might want to execute a package from the command line in silent mode, or you may want to run it from an external application or you may want to run some SSIS packages within a batch file. SSIS provides a Command Line Utility to support such cases and execute a package without need of any specific GUI.

In this recipe we will execute a package from the Command Line Utility and will discuss different options for execution.

Getting ready

We need to have an SSIS project deployed on SSMS from Chapter 9, Deployment.

How to do it...

  1. Open the Command Prompt and go to this path:
    C:\Program Files\Microsoft SQL Server\110\DTS\Binn

    And ...

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