dtsx file), you are always placed in this dtexecui environment (just as you automatically start up Microsoft Word when you double-click a Word document). When you double-click any filesystem-stored SSIS package (that is. You can choose to stop the execu- tion from here. Figure 52.42 shows the Package Execution Progress console during a package execution. You start it up from the command prompt: c:> dtexecui Using this Package Execution utility is really the best way to create new command-line executions for SSIS packages and to run them easily. This GUI displays all the available options and ensures the use of the correct syntax (see Figure 52.41). You can create new command-line dtexec executions visually with the assistance of the Package Execution utility, which you open through dtexecui. In addition, some dtexec command-line options support features in SSIS, such as the options to pass in connection strings and manage checkpoints. Other dtsrun command-line options don’t have direct dtexec equivalents. Some dtsrun command-line options have direct dtexec equivalents, such as the options for providing a server name or package name or for setting the value of a variable. Before you begin to use the dtexec utility, you should execute it at a command prompt with the help option set only and pipe the results into a text file: c:> dtexec /? > dtexec.txt You will quickly see all the main options and how similar this is to dtsrun (in SQL Server 2000). It has been taken over by the dtexec utility, which is bigger and better and has more options and values to serve your every SSIS package execution need. ptg 2135 The Package Execution Utility 52 NOTE You could also execute this new package by using the dtexec utility at a command prompt: C:> dtexec /FILE “C:\HotCustomerPlus.dtsx” The Package Execution Utility The dtsrun utility in SQL Server 2000 is no longer used within SQL Server 2008. FIGURE 52.39 Control of flow between the old data flow and new data flow tasks. That’s it: you have popu- lated the data mart and created data in an flat file for distribution to the sales team. Choose Execute, and the package executes and shows all results in the execution console, as shown in Figure 52.40. dtsx file, which automatically invokes the package execution utility. To execute the package, double-click the. Ptg 2134 CHAPTER 52 SQL Server Integration Services 10.