Insert data into table-valued parameters (Native Client OLE DB provider) Learn about the two models that the SQL Server Native Client OLE DB Provider supports for the consumer to specify data for ...

explicitly identify each table with a specific command. You can insert specific values into a table with an Identity column, but, to do so, you must first set the IDENTITY_INSERT value to ON.