| Autor: |
Misner, Stacia |
| Předmět: |
|
| Zdroj: |
SQL Server Magazine; Sep2011, Vol. 13 Issue 9, p12-16, 5p, 3 Color Photographs, 1 Diagram, 2 Charts |
| Abstrakt: |
The article discusses ways on how to prevent performance problems when designing SQL Server Integration Service (SSIS) packages. It says that understanding control flow performance and Data Flow Task operations are important to optimize performance. It cites various guidelines high performance of source component, transformation, and destination component bottlenecks which include reducing the numbers of columns, the use of SQL Command option, and optimizing cache for Lookup transformations. |
| Databáze: |
Complementary Index |
| Externí odkaz: |
|
