Write Data returns "No Columns Returned"

[mszpot89]

I made a ODBC connection and wanted to add excel data to the MS SQL Server data.

On Write-in DB step I get the Columns error. Is there a specific format of table name that has to be applied in Table name field?

The table is part of a schema but "schema_name.table" doesn't help.

[mszpot89 · Accepted solution]

Ok - I found it :)

Table name in Write in-db should go like this: Database_name.schema.table