SSIS: Using variable in OLE DB SQL command text
Posted on 2011-02-15
Is there a way to reference a variable as part of the SQL command text in the OLE DB source editor?
For example if I have a variable defined as myVar::
SELECT myVar, Account, CustName from Customers
resulting in output of:
RESIDENTIAL, 100, Steve
RESIDENTIAL, 200, Jim