PreSQL Error with Output Tool for SQL Server DB

[kherty]

I have created a workflow that runs and executes a presql statement on a SQL Server database.  I have another user who's DB connections are configured exactly the same as my Designer installation, however, when they try and execute the same workflow, they get an "invalid object" error?   I have attached a word .doc which has screenshots of both of our DB connection settings and the flow executing properly on my machine and the error the other user receives. Can anybody help us edit this Designer workflow so it can be used by both of us? Thanks!

[mceleavey · Accepted solution]

Hi @kherty ,

have you tried praying to the SQL gods?

Failing that, it may be that for the other user it's not resolving the full table name, because of reasons (known only to the SQL gods). Get the other person to connect to that source using the input tool, go to the table picker, select the table and add it. Then go to the SQL tab and see what the name of the table is in that sql select script. This will give you the name of the table from their connection.

At least will see where the problem lies.

M.

[kherty]

Thank you!  Wanted to make sure I made it back on here to thank you for the solutions.  She was able to see what the connection information/table syntax was and update it.

APPRECIATE YOU!

Wendy.