Performance tuning at Destination level in SSIS

·         Destination as Flat File, try to take the file local to the system.

·         Destination as Database (Table)

§  Use data access mode as “fast load” to load the data much faster.

§  Use data access mode as SQL Command to load any required rows and columns.

§  The table contains, indexes, triggers, and then loading will be slow. So we need to disable (or) drop them, later the loading is finished recreate or enable them.