Home Forums SQL Server 2005 Business Intelligence SSIS - Transfer SQL Server Objects Task - Performance RE: SSIS - Transfer SQL Server Objects Task - Performance
prathysql
SSC Journeyman
Points: 88
More actions
July 16, 2013 at 3:39 pm
#1633026
What destination you are using?
I recommend using OLEDB destination with fast load.
This will use Bulk Insert which eventually improve performance.
SQLCAT team published really nice paper about SSIS best practises .Worth reading
http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
Hope it helps!
P