Microsoft
70-458 · Question #37
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination…
The correct answer is C. OLE DB Destination with Fast Load. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. 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?
Options
- AADO NET Destination with Bulk Insert
- BSQL Server Destination
- COLE DB Destination with Fast Load
- DADO NET Destination without Bulk Insert
- EOLE DB Destination without Fast Load
How the community answered
(44 responses)- A9% (4)
- B2% (1)
- C84% (37)
- D5% (2)
Community Discussion
No community discussion yet for this question.