Execute SQL

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
        <Package Name="Package1" ConstraintMode="Parallel">
                <!-- This Execute SQL task processes a query in the SqlQuery variable.
                    It also returns a full result set and stores it in the Result variable. -->
                <ExecuteSQL Name="Execute SQL Task 1" ConnectionName="AdventureWorks" ResultSet="Full">
                    <VariableInput VariableName="User.SqlQuery" />
                        <Variable Name="SqlQuery" DataType="String">select ProductID, LocationID, Shelf, BINARY_CHECKSUM, Quantity
                            from AdventureWorks.Production.ProductInventory
                            where Quantity &lt; 100</Variable>
                        <Variable Name="Result" DataType="Object"></Variable>
                        <Result Name="Result" VariableName="User.Result" />