Рет қаралды 19,006
video talks about
SSIS Performance Tuning Tips
SSIS Performance Tuning Tips and Tricks
SSIS Performance Tuning Techniques
Performance Tuning Tips
Performance Tuning in ssis
a. When loading huge data , Transactions load
1. drop all non clustered indexes and Clustered Indexes
2. Load the data
3. Create all the Indexes
Master data -- not more than 1000
b. Select Only Required Columns
c. Avoid Asynchronous transformations
d. Try to reduce Blocking/Semi blocking transformations.
Step by step SSIS Training videos
SSIS Tutorial
more videos at
/ @training2sqlmsbi