Output Data - How to specify Schema and Output Table Name for SQL Server Database

I am trying to append data to an SQL Server Database table. I have set the Output Data tool up, established a connection to the database and it has prompted me for the table name (which I have entered) but when I try running my job it errors: "Error: Output Data (13): Error opening query: Microsoft OLE DB Provider for SQL Server: Invalid object name 'Test'.\42S02 = 208". I think it has something to do with the schema (the table is not in the default schema) and so it cannot find it. Can you specify the schema anywhere? Or am I just doing something completely wrong? It has worked for me before but the table was in the "dbo" schema so that is why I am assuming this is causing issues. Thanks in advance.

Output

Database Connection

Accepted answers

jdunkerley79

Have you tried useing [Schema].[TableName] for the table name to push to.

I think that should work.

All comments

jdunkerley79

Have you tried useing [Schema].[TableName] for the table name to push to.

I think that should work.

mpurdy

Thanks for the feedback. I thought I had tried that without success but I have gone back and it has worked (maybe I was missing the square brackets?). Sorry for the silly question. Thanks again!

TylerG

Hello, here's what worked and also what did not work.

\SQLEXPRESS|||[Sandbox].[Test1]
\SQLEXPRESS|||[Sandbox].[dbo].Test2
\SQLEXPRESS|||Sandbox.dbo.Test3

#1 Failed. (brackets, w/o DBO)

#2 Passed. (mostly brackets, w/ DBO)

#3 Passed. (no brackets, w/ DBO)

Output to SQL Server with Alteryx Designer

Best,

Tyler Garrett

apozzy

Does anyone know how this can be done dynamically? We need to be able to move our workflows between dev/uat/production environments without anyone having to touch the workflows. So the db/schema/connection info needs to change to point to the correct environment by being updated dynamically. We want to use relative paths to store config files which would contain the connection info for each environment, and have Alteryx read the config and update the output tool with the correct info on the fly.

Can this be done? If so, can anyone help?

thanks!

Alex

FreeRangeDingo

I was trying to work thru an output tool that wouldn't write to SQL, and this thread was helpful. To add to the information.....

In my use case, I was using an aliased Gallery data source. This is what worked for me -- aka:GalleryAliasName|||DatabaseName.dbo.OutputTableName.

No brackets were required.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703