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

Chapter 12. Execution

by Reza Rad

In this chapter, we will cover the following topics:

  • Execution from SSMS
  • Execution from a command-line utility
  • Execution from a scheduled SQL Server Agent job

Introduction

SSIS packages and projects should be run on a machine that is usually called an SSIS server. In some scenarios companies decide to use the same database server as an SSIS server, and in some cases, companies decide to use a dedicated server as an SSIS server. Choosing between a dedicated SSIS server or using an existing database server as an SSIS server is a decision that requires the consideration of resource consumption for running SSIS packages, expected load, and availability of servers.

Running, or in the other words, the execution of SSIS packages ...

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