Using SQLBulkInsertData with different schema

Malte Reiff

Hi all,

Is there a way to use  SQLBulkInsertData with a schema different from "dbo"? The command works, if the table is created in "dbo" schema but we were not successful with different schemas regardless of the nomenclature. We tried the following:

"[schema].[table]"
"schema.table"
"schema].[table"

We are using on-prem v12.

Any ideas?

Best regards,
Malte

ivan-rebo

i briefly tried this with SQL server and it worked :

 SQLData dt2 = SQLDataReadTableDefinition(sql, "Table_3");
    VariantList row3 = CreateVariantList();
    Append(row3, 4);
    Append(row3, "test");
    SQLDataInsertRow(dt2, row3);

    SQLBulkInsertData(sql, "test.Table_3", dt2);