Quick SSIS Throughput Test
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:
Click on the Data Flow tab or double click the Data Flow Task and Add on a Flat File Source
Double click on the Flat File Source to edit and select “New” to create a new connection:
In the Flat File Connection Manager Editor click Browse and point it to your CSV file:
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:
Now Run the package and look at the progress tab:
If you scroll to the bottom of the data. You can find a row that shows the amount of data you loaded into SSIS:
In my case 96601 rows of data. A few rows down you also get the amount of time it toke to load the data:
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.