An quick test to see the throughput of SSIS and how fast its loading in data, is to do a simple run of loading a source destination and then run it to look at the Progress tab.

An example of this is:

Download or move a large csv file to a box with SSIS  installed (im using a csv file from http://seanlahman.com/baseball-archive/statistics/)

Create a new SSIS project and package in SSDT.

Add a Data flow to the Control Flow:

Image

Click on the Data Flow tab or double click the Data Flow Task and Add on a Flat File Source

Image

Double click on the Flat File Source to edit and select “New” to create a new connection:

Image

In the Flat File Connection Manager Editor click Browse and point it to your CSV file:

Image

Set up the File as needed (Check browse to make sure the data looks correct) click OK when your happy. Follow up and close the Flat File Source:

Image

Now Run the package and look at the progress tab:

Image

If you scroll to the bottom of the data. You can find a row that shows the amount of data you loaded into SSIS:

Image

In my case 96601 rows of data. A few rows down you also get the amount of time it toke to load the data:

Image

In my case 0.499 seconds.

To get a throughput of how many rows im loading a second I simply divide the rows by time:

96601 / 0.499 = 193589 Rows a Second.

Advertisements