MSBuild.ExtensionPack.SqlServer Namespace

MSBuild Extension Pack

previous page next page
MSBuild.ExtensionPack.SqlServer Namespace MSBuild Extension Pack Help 4.0.12.0

Overview

This namespace currently hosts the various SqlServer tasks
Classes
  Class Description
Public class Code example BuildDeploymentManifest
This Task can be used to translate SSIS projects (.dtproj files) into an SSIS deployment manifest

Remote Execution Support: NA
Public class BuildNumber
Public class Code example SqlCmd
Wraps the SQL Server command line executable SqlCmd.exe.

Valid TaskActions are:

Execute (Required: CommandLineQuery or InputFiles Optional: Database, DedicatedAdminConnection, DisableVariableSubstitution, EchoInput, EnableQuotedIdentifiers, Headers, LoginTimeout, LogOn, NewPassword, OutputFile, Password, QueryTimeout, RedirectStandardError, Server, SeverityLevel, SqlCmdPath, UnicodeOutput, UseClientRegionalSettings, Variables, Workstation)

Remote Execution Support: Yes
Public class Code example SqlExecute
Valid TaskActions are:

Execute (Required: ConnectionString, Sql or Files Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors, StripMultiLineComments Output: FailedScripts)

ExecuteRawReader (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: RawReaderResult, FailedScripts)

ExecuteReader (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: ReaderResult, FailedScripts)

ExecuteScalar (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: ScalarResult, FailedScripts)

Remote Execution Support: NA
Public class Code example SqlVersion
The SqlVersion task provides the ability to manage multiple build versions in a simple database table.

Valid TaskActions are:

GetVersion (Required: BuildName, DatabaseName Optional: Delimiter, FieldToIncrement, PaddingCount, PaddingDigit Output: Build, Major, Minor, Revision, Version)

Remote Execution Support: Yes
Public class SqlVersionDataClass
previous page start next page