SSIS - Fast Parse

, 2008-12-15

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.

     

  • Rate

    Share

    Share

    Rate

    Related content

    Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

    Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

    2009-02-23

    1,567 reads

    Networking - Part 4

    You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

    2009-02-17

    1,530 reads

    Speaking at Community Events - More Thoughts

    Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

    2009-02-13

    360 reads