I'm trying to execute a tsql code on a database task. The tsql code executes without any issue on the SSMS. But when manually testing the task from VisualCron I get this error:

Error in SQL query: Must declare the scalar variable "@xxxx".
Exception in Task: Must declare the scalar variable "@xxxx"

What else do I need to do? I thought that the tsql code will be fully executed on the database engine, so no need to declare any variables on task creation. Thanks.

Are you using using SQL Text or Stored procedure option?

---

I'm using SQL Text. I found what was triggering the error. The check box "Split and run multiple queries with semicolon as separator" was checked. Unchecked and now it's ok. Thanks.

Great, thanks for the update.

---