Invalid Column Name Error in SmartConnect SQL Task- How to Fix This

This video explains how SmartConnect’s variable replacement can unintentionally change a SQL column name, turning 'Workflow_Status' into 'Workflow9'. You’ll see how to identify the issue, how a SQL Profiler trace can reveal the exact SQL SmartConnect executes, and several ways to correct the problem, including renaming the source field, using case sensitivity to prevent unwanted replacement, and using dynamic SQL when those options aren't available. If you'd like to read the help article that goes with this, click here.