SimplySql icon indicating copy to clipboard operation
SimplySql copied to clipboard

Invoke-SQLBulkCopy should support controlling options (MSSQL)

Open mithrandyr opened this issue 4 years ago • 0 comments

The SqlBulkCopy class by defaults uses the option "Keep Identity" -- which requires alter table permissions. There are additional options that, if not specified, require alter table permissions. See Microsoft Documentation: Bulk Insert: Security.

Possible options, provide option flags to include (comma delimited list)?

mithrandyr avatar Feb 01 '21 20:02 mithrandyr