This task will execute a scalar query (a query which returns a single result) on an OLEDB data source. The result can be accessed by the next task in the workflow using the ‘Output from the previous task’ option.
The SQL query to be executed, see below for an example.
The OLEDB Connection to use. See the Connecting to an OLEDB Database article if you require more information on how to create/manage connections.
See Common Task Settings
You can find an example of how to use this task in the OLEDB Connector tutorial.
Sample query, which will select the sum of the Balance column from the Accounts table:
SELECT SUM(Balance) FROM Accounts
Back | Edit on Github