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