This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think it might be throwing you an error because the table you are attempting to output too already exists.
Make sure to adjust the highlighted piece of your output to not "Create New Table", if your table exists in your database already. You can change it to "Delete and Append" or "Append" depending on how you are attempting to update the table.
"Delete and Append" = Drop all data and put the data you are feeding it to the table, keeping the same table structure
"Append" = Keep all the data, just add the new data to in the table with the rest of the rows.
"Overwrite Table (Drop)" = Drop entire table structure and data from database and re-create from scratch
If you are using the In-DB tools you have the same options as the output tool.
I was getting this error in one of my workflows too and after many hours of scouring forums I discovered that I had left a space before the schema name in the 'Table Name' textbox. When I removed this, the error disappeared.
This may not be the same issue for other users, but I thought I would mention just in case it helps anyone else.
I was having the same issue when overwriting an existing table on SQL Server using the Data Stream In tool. When I removed the [square brackets] around the schema in the 'Table Name' window, the issue was resolved.
I've had the same issue. In my case the problem was caused by a database view that was referencing to this table. As soon as I dropped the view I had no more problems overwriting the table. Offcourse you're losing the view so as a solution I dropped the view in a pre SQL statement and created it again in the post SQL statement.