Let's Learn SSIS

1. Efficient way to bulk load data in .NET using SqlBulkCopy: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

This SqlBulkCopy outperforms the ADO.NET SqlDataAdapter bulk operations a lot. Check out the performance analysis in this link: http://sqlblog.com/blogs/alberto_ferrari/archive/2009/11/30/sqlbulkcopy-performance-analysis.aspx

looks very impressive.

2. Bulk Insert using SSIS: http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server (impressive 22GB in over 8 minutes)

3. Data Loading Performance Guide: http://msdn.microsoft.com/en-us/library/dd425070.aspx

Creating SSIS Package

Top 10 SQL Server Integration Services Best Practices

Code demo

Data Entity Framework

Tips:
1. Table need a primary key to make insert working