This task will execute a scalar query (a query which returns a single result) against SQL Server. This is useful for fetching data to be used in Dashboards
The maximum time to wait for the query to execute.
The SQL Query to be executed. See below for an example.
The SQL Connection to use. See the [Connecting to SQL Server 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 SQL Server Connector tutorial.
Sample query, which will return the total balance across all accounts:
SELECT SUM(Balance) FROM Accounts
Back | Edit on Github