Breaking News
Loading...
28/07/2013

SSIS - SQL Server destination is the fastest way to bulk load data

Today while finding out about SSIS performance tuning I saw an useful information:

Here is the original information:
The SQL Server destination is the fastest way to bulk load data from an Integration Services data flow to SQL Server. This destination supports all the bulk load options of SQL Server – except ROWS_PER_BATCH. 
Be aware that this destination requires shared memory connections to SQL Server. This means that it can only be used when Integration Services is running on the same physical computer as SQL Server.


Refer here:
http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx

0 comments:

Post a Comment

 
Toggle Footer