Skip to content
+1-888-319-3663

COMMUNITY FORUM

sql tasks

Daniel asked 4 years ago
Are you able to get the actual query that is being executed when a sql task runs?  I’m using variables so I want the see the statement that is being sent to the sql server.
I have a task running after each successful document and every document is successful but the the field I’m updating in the task is not being updated and I’m not getting any errors…
Answers
Patrick Roth Staff answered 4 years ago
There is nothing in SC that gives you the SQL script that ran.  You would have to run a SQL Profiler trace.
 

If you would like to submit an answer or comment, please sign in to the eOne portal.