SSIS Variables In SQL Statements

You can use the SQL task in SSIS to compose a quick SQL statement that returns some results or does some DML that returns nothing.

If you try and put in your SQL statement the way you might normally do it in .NET, you are going to find out that SSIS is not fond of the @ syntax for parameters.

You will see an error like this when you try and parse.

You can instead write a statement like this...

INSERT INTO tblStores (StoreNumber, StoreName)

VALUES (?, ?)

Then in the parameter mapping, define your parameters with the names 0 and 1 for their respective "?" placeholders.

This ALSO won't parse, but it will work if you just "OK" your way out of the settings box.