<div>
so the only way to incorporate a variable like that is to build a variable containing the SQL string, there is now way to reference it via @User:: or anything like that?
</div>


so the only way to incorporate a variable like that is to build a variable containing the SQL string, there is now way to reference it via @User:: or anything like that?

<div>
Yes you reference it using the source component after selecting the &quot;SQL Command from variable&quot; drop down.
</div>


Yes you reference it using the source component after selecting the "SQL Command from variable" drop down.

<div>
<div class="content wysiwyg-content">
Is there a way to reference a variable as part of the SQL command text in the OLE DB source editor?<br />
<br />
For example if I have a variable defined as myVar::<br />
SELECT myVar, Account, CustName from Customers<br />
<br />
resulting in output of:<br />
RESIDENTIAL, 100, Steve<br />
RESIDENTIAL, 200, Jim<br />
etc.<br />
<br />

</div>
</div>


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
etc.



SSIS: Using variable in OLE DB SQL command text

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.