September 2012
Beginner to intermediate
672 pages
21h 25m
English
book
Microsoft® SQL Server® 2012 Integration Services
by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Content preview from Microsoft® SQL Server® 2012 Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...