This section provides an overview of what ssis is, and why a developer might want to use it.

It should also mention any large subjects within ssis, and link out to the related topics. Since the Documentation for ssis is new, you may need to create initial versions of those related topics.

1. Right click on the Data Flow Task and select property. DefaultBufferMaxRows and DefaultBufferSize properties can be changed to improve data load performance.
2. Multiple Data Flow Task can be executed in parallel for better performance.
3. Each Task has two flows success and failure. It is important to handle the failure flow to make the package more robust.
4. Inside the Data Flow Task right click on the blue arrow and select Enable Data Viewer to check data flow at run-time.
5. If any column is deleted in the source or the destination to check which column get deleted. Inside Data Flow right click on the blue arrow and select Resolve References, in the new window we can see Unmapped Output columns (left) and Unmapped Input Columns (right).