SSIS 데이터 이관 속도

• ODBC Tasks  : 5 minutes 57 seconds 
• ADO NET Tasks  : 11 seconds
• OLEDB Task
• fast load, table lock option: 5 seconds.
• table or view option : 2 minutes and 21 seconds
• sql command :  2.85 seconds.
• SQL Server Destination
• oledb destination : 2.5 seconds.
• T-SQL Tasks
• 프로시저 생성해서 작업 : 1.8 seconds!   -> 이건 같은 DB 일 때 네요.

 

http://www.mssqltips.com/sqlservertip/2684/importing-sql-server-data-using-ssis--which-option-is-fastest/