O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

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 11. Running SSIS Packages

Ways to Run SSIS Packages

Although there are lots of ways to run an SSIS package, without a doubt, dtexec is still the most frequently used method. It is also the basis for some other approaches (such as SQL Agent, which is introduced later in this chapter, which calls dtexec to do its work). It’s important to clearly understand the capability of the tool.

The dtexec utility is a command-line tool; the executable file is named dtexec.exe. The utility has both 32-bit and 64-bit versions. By default the 64-bit version is ...

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