(Integration Services) Stress Test 1: Flat to Flat

First stress test: Pass 6 millions of records from a Flat File, to CSV file.

In this test (with SSIS), the first run was sufficient to document and compare because the times were reasonable, without having to modify the design and SETTINGS to reduce the execution time.


Objective: To measure elapsed time reading and writing 6 million rows, from Flat file, to .CSV file, working on local disk.
Rows: 6.024.000 M
Columns: 37 Columns
Resources: Virtual machine with: 2 GB RAM, Integration Services like main process over the virtual plataform. The resources used are anecdotal, today, Any production environment has enough processing power for current and future requirements. The objective here, is to build, to execute and to measure with the same environment (regardless of the limited resources)

Design & Run
Elapsed time (s) 148 sec.
Rows per sec (avg)

40.739 rows/sec

Summary of log