Wednesday, 15 November 2017

How to use Fast Parse Property in SSIS Flat File Source

What is Fast Parse Property in SSIS Flat File Source
In General, when you loading the data from Flat File to a Destination, the Source data will Parse, which means it validate the source Columns Datatype against the Destination Datatype, to ensure right data flowing into the destination.

The validation will do for the Date and Numeric data columns. This validation may consumes the time, when we are loading large datasets.
If you are sure that Input data source is trusted one having the valid data, then you skip this validation by enabling the FastParse=True, which makes you process execution faster.

Suppose we have a Task where we loading the data from Flat File to SQL Destination as follows :
Here I did not set any FastParse Properties ( by Default , FastParse=False )

Now the Execution time when FastParse=False :
Finished, 1:54:43 PM, Elapsed time: 00:00:00.217

Now I will enable to FastParse Property to the Numeric and Date Columns of the Flat File Source as follows :
1. Right Click on Flat File Source  then Go to Advanced Editor :
2. Next in Advanced Editor > Input and Output Properties set the Properties as follows:
Go to Flat File Source Output > Output Columns
Next select each Numeric and Date columns and set the "FastParse=True" under Custom Properties.

Now the Execution time when FastParse=True :
Finished, 2:11:08 PM, Elapsed time: 00:00:00.172

When we are loading Large datasets then we see the more Variance in the Execution Time

Thanks, TAMATAM ; Business Intelligence & Analytics Professional

1 comment:

  1. Hiya! Quick question that's totally off topic.
    Do you know how to make your site mobile friendly? My website looks weird when viewing from my iphone 4.
    I'm trying to find a template or plugin that might be able to correct this issue.
    If you have any suggestions, please share. Thanks!


Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts