Solutions - Using a variable to count Employees imported from Excel in SSIS (SQL Server Integration Services)

Download and Copy the Employee_Data excel file to C:\Exercise_SSIS11.

1. Create a new SSIS project named Exercise_SSIS11.
2. Add a new variable Employee_Count in the variable window.

       .

        3.Create a new excel connection

   4.Add a data flow task

  

   5.Add an excel source.

  6. Add a rowcount and configure with variable

7.Add a script task

8.Add below code in script task

9. Execute the package 

You can download the project solution.