FastParse Property on Flat File Source in SSIS

Fast Parse is property available on Flat File Source, by enabling that we tell the Flat File Source to ignore validation for specific columns on which we trust the data will be always in the correct format and we don't need to validate.

The validation will do for the Date and Numeric data columns. This validation may consume the time when we are loading large datasets.

If we are sure that Input data source is trusted one having the valid data, then we can skip this validation by enabling the Fastparse=True, which makes you process execution faster.

Let’s see the example

Taking data flow task

   

Taking source as the flat file and creating the connection.

  

   

Right click on the Flat File source to set the fast parse property.

   

Click on the Show, advanced editor.

Now go to Input and output property and navigate to the output column.

      

By default value of the fastparse is false.

Remember here we can set the fastparse property on the individual column and it validates only Date and Numeric data columns. If we set for the string it will show error see below.

 

So be careful when you are setting the fastparse property.

Now setting this true.

Fastparse = true

For each column.

   

Now, this ignores the validation on the columns.

Now I am connecting to the destination.

 

 

Now running the package.

Package executed successfully.