Runs a scalar-valued Transact-SQL query against a target instance of SQL Server. Only one column can be specified in a SELECT ...

Runs a scalar-valued Transact-SQL query against a target instance of SQL Server. Only one column can be specified in a SELECT statement; additional columns beyond the first are ignored.  The resulting query should return only one row; additional rows beyond the first are ignored. If the query returns an empty set or NULL, then the condition expression built around ExecuteSQL will evaluate to false. ExecuteSql supports the On Demand and On Schedule evaluation modes. A SELECT statement can use the following variables, which will be substituted at run time by using ADO.NET parameter substitution:
@@ObjectName - corresponds to the name field in sys.objects. The variable will be replaced with the name of the current object.
@@SchemaName - corresponds to the name field in sys.schemas. The variable will be replaced with the schema for the current object if the current object belongs to a schema.

Run once' is not a valid schedule option for an individual data source that is queried in a data refresh operation. Please ... Run the Microsoft .NET Framework SDK command line tool Assembly Registration (regasm.exe) to update the metadata for Mic ... Running the Merge Agent process at this time would exceed the maximum number of processes allowed by this publication. The ... RunningValue or RowNumber functions used in the cells of the {0} '{1}' refer to grouping scopes in both the columns and rows ... Runs a scalar-valued Transact-SQL query against a target instance of SQL Server. Only one column can be specified in a SELECT ... Runs an application or batch file. Run pre-existing batch files, command-line utilities, third-party tools, or complex programs. ... Runs an SQL statement for each row in a data flow. For example, call a 'new employee setup' stored procedure for each row ... Runs another package as part of this control flow. For example, share a common logic between two different packages, or group ... Runs SQL Server 2000 DTS packages that were developed by SQL Server 2000 tools. You can run packges that include both Execute ...