Performance tuning at Data Flow in SSIS

·       Proper maintenance of Delay Validation:

Delay validations means True/False in between the components. True means the validations of component is delayed until the execution of other component is finished.

·        BLOB Temp Storage path:

This property is specifying at the time of working with Binary large objects such as Images, Media files etc.

·         Increase the size of Buffer:

       (See this link)

·       Engine Threads (parallel):

The default value is “10”, it will increase more threads it runs more parallel and uses more processes to finish the dataflow operations.

·       Run In Optimized Mode:

If it’s true, the dataflow avoids unnecessary transformations, conservations, operations etc.

·       Optimize event handlers.