Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Try It



55

FIGURE 610

38. Drag the Lookup Match Output Data Path onto that task.

39. Drag the green arrow from the Derived Column task onto the Union All task.

40. Add a Conditional Split task onto the design surface.

41. Drag the green arrow from the Union All task onto the Conditional Split.

42. Double-click the Conditional Split task.

43. In the lower pane of the Conditional Split Transformation Editor, type Give Raise in the

column labeled Output Name.

44. Then type the following expression in the column labeled Condition:

DATEDIFF(“yy”,RateChangeDate,GETDATE()) > 10

45. Finally, type No Raise in the column labeled “Default output name.” See Figure 6-11.

Click OK.

889633c06.indd 55 8/16/10 9:45:38 PM

56



LESSON 6 Using the Data Flow

FIGURE 611

46. Drag a Derived Column task onto the design

surface.

47. Drag the green arrow from the Conditional

Split task onto the newly added Derived

Column task. A dialog box like the one in

Figure 6-12 will appear.

48. Select Give Raise from the drop-down list

labeled Output and click OK.

49. Double-click the derived column.

50. In the lower pane, in the column labeled

Derived Column Name, type NewRate.

51. In the column labeled Derived Column, select <add as new column>.

52. In the column labeled Expression type Rate*1.10 and ...