Hands-On Microsoft SQL Server 2008 Integration Services part 29. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 258 Hands-On Microsoft SQL Server 2008 Integration Services 2. Expand the SQL Server Agent node in Object Explorer and right-click Jobs then choose New Job from the context menu to open the New Job dialog box. 3. Type Running Mailing Opportunities in the Name field. Ensure that the Enabled check box is ticked before moving on to the Steps page. 4. Go to the Steps page and click New to create a new step for this job. In the Step Name field of the New Job Step window type Executing Mailing Opportunities Step. 5. In the Type field click the down arrow to display the list of job types and choose SQL Server Integration Services Package. As you choose this option the window changes to include the options for running an Integration Services package. 6. In the Run As field leave SQL Agent Service Account selected. 7. In the General tab set the Package Source field to SSIS Package Store type localhost in the Server field and leave Use Windows Authentication selected in the Log On To The Server area. Click the ellipsis button next to the Package field to choose the Mailing Opportunities package under the MSDB storage folder. Click OK. Note the package path shown in Figure 6-6. 8. Click the Advanced page in the New Job Step window to see the available options. You can specify what should happen on the success or failure of a step. The default for success of a step is to go to the next step and the default for the failure of a step is to quit the job and report failure. You can also specify the number of retry attempts and the time to wait between retries here as well as record output in an output file or table. Click OK to close this dialog box. You should see the package listed in the Job Step List area. Notice the arrow buttons on the lower-left side of this page you can use these to move your job steps up and down and hence change the order in which they are executed. Exercise Create a Schedule to Execute the Package In this section you will be creating and adding a .
