You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on
Server A. The package includes a data flow and is executed on ServerB. The destination table has its own
identity column. The destination data load has the following requirements:
The identity values from the source table must be used.
Default constraints on the destination table must be ignored.
Batch size must be 100,000 rows.
You need to add a destination and configure it to meet the requirements. Which destination should you use?
A.
ADO NET Destination with Bulk Insert
B.
SQL Server Destination
C.
OLE DB Destination with Fast Load
D.
ADO NET Destination without Bulk Insert
E.
OLE DB Destination without Fast Load
Explanation:
According to these references, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms141237.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms139821.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms141095.aspx
C.
OLE DB Destination with Fast Load
Why not B? seems to me that B can fulfill all requirement too, thanks!
“Batch size must be 100,000 rows” – Only OLE DB has the option to specify number of rows in the batch.
And SQL destination only supports the same local server (server a and server b in this question)