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

Hands-On Microsoft SQL Server 2008 Integration Services part 53. 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. . | 498 Hands-On Microsoft SQL Server 2008 Integration Services And add the following script into the Main subroutine Update the with UPDATED message if the processing has started in this run Otherwise . for any other status such as UPDATED or ELSE do nothing. If HandshakeMessage .Value OK Then C SSIS RawFiles UPDATED False End If 16. After completing the middle branch let s complete the leftmost branch which is very simple as there is very little logic to implement in this branch other than that it has to be attached to the final Script task. Click the Determine Workflow Using Handshake Script task and drag the green arrow on to the final Script task labeled as Update HandshakeFile. This will set a constraint on the final Script task to be executed only when the two preceding tasks the first Script task and the Data Flow task get executed. We do not want this as the workflow is mutually exclusive and both tasks will never be executed in the same run. We need an OR constraint that is the final Script task should execute when either of the tasks complete. Double-click the newly added green line and change the multiple constraints condition from Logical AND to Logical OR as shown in the Figure 11-6. Also select Expression in the Evalutation operation field and set Figure 11-6 Setting the Logical OR precedence constraint Chapter 11 Programming Integration Services 499 Expression as follows as we want the workflow to run via this branch only when the HandshakeMessage value is UPDATED. Close the Precedence Constraint Editor Dialog box. HandshakeMessage UPDATED 17. Now let s complete the rightmost branch of the work flow. Add another Script task in the package control flow on the right side and above the Data Flow task and join the first Script task and the new Script task. Open the precedence constraint select Expression in the Evaluation Operation field and set Expression as follows. .