SimplySql
SimplySql copied to clipboard
Invoke-SQLBulkCopy should support controlling options (MSSQL)
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)?