Reference Source Column in SQL Command

Published: Oct 06, 2016
Post Author Written by eOne Solutions

I am referencing a source column in my SQL Command task and receiving an error “Incorrect syntax near myvalue”. Below is the code I am using in my task.

DECLARE @MySQLVariable varchar(max)

When referencing a source column or a global variable in a SQL Command Task, SmartConnect will replace the source column name or global variable name with the actual value. If that value is a string, we need to put single quotes around the source column or global variable so that when it is replaced, it will become the literal string.

As the code below illustrates, we use single quotes to represent the source column value.

DECLARE @MySQLVariable varchar(max)
Set @MySQLVariable =  ‘_MY_SOURCE_COLUMN’

Similarly, we can do the same for global variables

DECLARE @MySQLVariable varchar(max)

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.