SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS - Fast Parse

I had another chance last week to answer an email follow up question from the session Brian and I gave at PASS.  This made for a great blog opportunity so I thought I would write about using Fast Parse in SSIS.  Hopefully I can explain it even more basic then Microsoft does on MSDN.

Using fast parse can drastically improve performance of your package when using a flat files source or data conversion transform by basically not validating the columns that you specify.  Keep in mind that these columns must be a date, time, or integer data types to enable fast parse. 

fastparseTo enable fast parse on either a flat file source or a data conversion transformation use the following steps that can also be found on the MSDN link provided.  The provided image highlights these steps.  Keep in mind that this must be set for each individual column and can only be used on the column types stated previously.

  • Right-click the Flat File source or Data Conversion transformation, and then click Show Advanced Editor.

  • In the Advanced Editor dialog box, click the Input and Output Properties tab.

  • In the Inputs and Outputs pane, click the column for which you want to enable fast parse.

  • In the Properties window, expand the Custom Properties node, and then set the FastParse property to True.

  • Click OK.


  • Devin Knight

    Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


    No comments.

    Leave a Comment

    Please register or log in to leave a comment.