For previous projects we have used the OracleLoader to populate tables in Oracle. The OracleLoader has an Options property that allows me to specify things such as KeepPrimaryKeys, DisableTriggers, etc.
The SqlLoader has no such property. Given that the primary key columns of our SQL Server tables are defined as Identity columns, how can I disable the auto-increment feature of the column to allow the original primary key values to be assigned?
I have tried using
Code: Select all
set identity_insert <my_table> off