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?
Comments