tailieunhanh - Hands-On Microsoft SQL Server 2008 Integration Services part 16

Hands-On Microsoft SQL Server 2008 Integration Services part 16. 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. . | 128 Hands-On Microsoft SQL Server 2008 Integration Services Figure 4-9 Setting an input parameter for Execute SQL task 11. You are now ready to Start Debugging from the Debug menu or by pressing F5. You will see the For Loop Container turning yellow and the package execution stopped at Execute SQL Task. Open the Locals window from the bottom left of the BIDS screen. If you don t find it there you can also open it by clicking Debug Windows Locals menu bar command. Expand the variables and scroll down to locate the User MonthCounter variable. Note that the value is set to 1. Now press F5 to continue processing. The Execute SQL Task will run and will turn green. After that the For Loop Container will start the second iteration by incrementing the value of User MonthCounter to 2 and the package will break again before executing the Delete monthly records task as shown in Figure 4-11. Note that the value of User MonthCounter variable is 2 now. 12. Switch to SQL Server Management Studio and run the following SQL Command to see the records left in the Sales table. SELECT FROM Campaign . dbo . Sales Note that the records belonging to month 1 have been deleted from the table with only 22 records left in the table. Chapter 4 Integration Services Control Flow Containers 129 Set Breakpoints - Delete monthly records Select the breakpoints in the task. For Loop Foreach Loop or Sequence to enable. Optionally select the number of times a breakpoint is ignored before execution is suspended on the breakpoint. Enabled Break Condition Hit Count Type Hit Count p Break when the container receives the OnPreExecute event Always 0 n o Break when the container receives the OnPostExecute ev. Always 0 r o Break when the container receives the OnError event Always 0 n o Break when the container receives the OnWarning event Always 0 o Break when the container receives the Onlnformation event Always 0 n o Break when the container receives the OnTaskFailed event Always 0 n o Break when the .