May 2007
Intermediate to advanced
432 pages
11h 43m
English
Content preview from Expert SQL Server™ 2005 Integration Services
Become 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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
9.3. Running Packages with DTExecUI
The primary way to manually execute a package is with DTExecUI.exe. This utility is a graphical wrapper for DTExec.exe and provides an easier way to produce the necessary switches to execute the package. Nearly all the same tabs and options you see in DTExecUI.exe will also be available when you schedule the package.
The quickest way to open the utility is from within Management Studio. To open it from there, right-click any package that you want to execute and select Run. You can also open the utility in Windows by selecting Start 
Run and typing DTExecUI.exe.
Before beginning the discussion of this utility, it's important to note that the utility is a 32-bit utility. The utility will run on a 64-bit machine, but it will wrap the 32-bit version of DTExec.exe. Later in this chapter, you'll learn about some tricks to use to run the package in 64-bit mode.
When you right-click a package and select Run, the first screen in DTExecUI.exe is filled out for you automatically. The first page (shown in Figure 9-4) points to the package you want to execute, and indicates where the package is located. If you select the Package Store to connect to from the Package source drop-down list box, you'll be able to see all the packages stored on the server, no matter where they are stored. Your other options are SQL Server or the File System. With the SQL Server ...
Become 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,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.