Breaking News
Loading...
14/08/2013

SSIS performance - Fast parse

One of the ways to increase performance in SSIS is set fast parse property to true.

Fast parse is available only when you use the Flat File source or the Data Conversion transformation. The increase in performance can be significant, and you should consider using fast parse in these data flow components if you can.

To set fast parse

  1. Right-click the Flat File source or Data Conversion transformation, and then click Show Advanced Editor.
  2. In the Advanced Editor dialog box, click the Input and Output Properties tab.
  3. In the Inputs and Outputs pane, click the column for which you want to enable fast parse.
  4. In the Properties window, expand the Custom Properties node, and then set the FastParse property to True.
  5. Click OK.
Refer here: http://technet.microsoft.com/en-us/library/ms139833(v=sql.105).aspx

0 comments:

Post a Comment

 
Toggle Footer