Wednesday, November 15, 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.

Scenario:
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

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

--------------------------------------------------------------------------------------------------------
Thanks, TAMATAM ; Business Intelligence & Analytics Professional
--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.