MSBI Tutor

The Aggregate transformation is used to perform aggregate operations/functions on groups in a data set. The aggregate functions available are Count, Count Distinct, Sum, Average, Minimum and Maximum. The Aggregate transformation has one input and one or more outputs. It does not support an error output. Aggregate Function Details AVERAGE Give the Average value of the Columns or Attributes value GROUP BY Derived the data set into Group SUM Give the SUM value of the Columns or Attributes value COUNT Give the number of item in Groups COUNT DISTINCT Give the Unique NON NULL Item MINIMUM Give the Minimum Number in a Group MAXIMUM Give the Maximum Number in a Group Step 1: Click Windows button and go to SQL Server 2008 R2 and run as a administrator. It shows  a bellow window. Step 2: Go to a views and create a new project ( Short cut of Ne

STEP 1: From the control flow items drag & drop the for loop container. STEP 2: Giving variables to the Package first. Process give right click & select variable option in that. Then we get 1 dialog box In the left side below variables click on add variable button we get Name, Scope, Data Type & Value. Give Name          Scope                        Data type      Value          intval          default Package          INT32               0          finval          default package          INT32               3 STEP 3: Now edit for loop. By giving right click on for loop we get edit option then click on it. By clicking on edit option we can get for loop editor In the dialog box we had for loop properties in that we have to give initexpression as @intval=0,  Evalexpression as@intval<=@finval, Assign expression as @intval=@intval+1. Then click on ok After click on ok button we get one dialog box Now go