For FMD_LOAD_BULK_DATA, can't use schema names - dim.Date versus Data.Date.

[SQLThomasMVP]

The table list does not take schema name, just table name

example - ('Data.Date') does not work, ('Date') does work.

But what happens if I have 2 table names the same, but are in different schemas.

[SQLThomasMVP]

it also does not work if there is no primary key.

[edkreuk]

For Bulk insert you need to have a PK, this is required to build the Bronze layer. Schema name I will check for you

[edkreuk]

Schema is not now also supported in the Bulk Pipeline @SQLThomasMVP