.NET API browser

Welcome to the .NET API browser – your one-stop shop for all .NET-based APIs from Microsoft. Start searching for any managed APIs by typing in the box below.

If you have any feedback, create a new issue in the dotnet/dotnet-api-docs repo.

Snabbfilter

SQL Server .NET SDK API-referens version 2019

NameDescription
ADODB Namespace
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask NamespaceThe Microsoft.DataTransformationServices.Tasks.DTSProcessingTask namespace provides the classes that define and support the Analysis Services Processing task (DTSProcessingTask) and the Analysis Services Execute DDL task (ASExecuteDDLTask).
Microsoft.DataWarehouse.Design Namespace
Microsoft.MasterDataServices.Services NamespaceProvides the classes that are related to services.
Microsoft.MasterDataServices.Services.DataContracts NamespaceProvides classes that are related to data contracts.
Microsoft.MasterDataServices.Services.MessageContracts NamespaceProvides classes that are related to message contracts.
Microsoft.MasterDataServices.Services.ServiceContracts NamespaceProvides classes that are related to service contracts.
Microsoft.SqlServer.Dts Namespace
Microsoft.SqlServer.Dts.Design NamespaceThe namespace Microsoft.SqlServer.Dts.Design contains classes and interfaces to create user interface elements and connect them to the tasks so properties of the tasks can be set.
Microsoft.SqlServer.Dts.ManagedConnections NamespaceThe Microsoft.SqlServer.Dts.ManagedConnections namespace contains connections that are managed connections, contained directly in a connection manager. If InnerObject is used on these classes, their value is returned. Other connection managers are native, and .InnerObject returns System.__ComObject. For all connection types, it is recommended that you set properties using Properties.
Microsoft.SqlServer.Dts.ManagedMsg NamespaceThe Microsoft.SqlServer.Dts.ManagedMsg namespace contains classes to assist the Integration Services developer in raising errors, warnings, informational messages, and other events.
Microsoft.SqlServer.Dts.Pipeline NamespaceThe Microsoft.SqlServer.Dts.Pipeline namespace contains managed classes that are used to develop managed data flow components. It contains the PipelineComponent class, which is the base class for managed data flow components, and the PipelineBuffer class, which is the managed implementation of the IDTSBuffer100 interface. The PipelineBuffer class marshals data flow buffers between the COM data flow engine and managed data flow components.
Microsoft.SqlServer.Dts.Pipeline.Design NamespaceThe Microsoft.SqlServer.Dts.Pipeline.Design namespace contains the interface that is used when developing a user interface for a data flow component.
Microsoft.SqlServer.Dts.Pipeline.Localization NamespaceThe Microsoft.SqlServer.Dts.Pipeline.Localization namespace contains the DtsLocalizableAttribute class, which supports the localization of properties common to most data flow objects.
Microsoft.SqlServer.Dts.Pipeline.Wrapper NamespaceThe Microsoft.SqlServer.Dts.Pipeline.Wrapper namespace provides the classes and interfaces used to create custom Data Flow components and to automate the Data Flow task.
Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2012 NamespaceThe Microsoft.SqlServer.Dts.Pipeline.Wrapper namespace provides the classes and interfaces used to create custom Data Flow components and to automate the Data Flow task.
Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2014 Namespace
Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2016 Namespace
Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2017 Namespace
Microsoft.SqlServer.Dts.Runtime NamespaceThe Microsoft.SqlServer.Dts.Runtime namespace contains the classes and interfaces to create packages, custom tasks, and other package control flow elements.
Microsoft.SqlServer.Dts.Runtime.Design NamespaceThe Microsoft.SqlServer.Dts.Runtime.Design namespace provides the classes and interfaces used to create and instantiate user interfaces for tasks and run-time extension objects.
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO NamespaceThe Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO namespace contains the interfaces and classes used to set properties on the ADO enumerator.
Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar NamespaceThe Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar namespace contains the classes and interfaces used to enumerate over the objects that are in a variable.
Microsoft.SqlServer.Dts.Runtime.Enumerators.Item NamespaceThe Microsoft.SqlServer.Dts.Runtime.Enumerators.Item namespace contains the interfaces and classes used to set properties on the ForEachItem enumerator.
Microsoft.SqlServer.Dts.Runtime.Enumerators.NodeList NamespaceThe Microsoft.SqlServer.Dts.Runtime.Enumerators.NodeList namespace contains the classes and interfaces used to enumerate a set of XML nodes that result from applying an XPath expession to an XML file.
Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO NamespaceThe Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO namespace is an enumerator containing classes and members for using SQL Server Management Objects (SMO). You can select what information to enumerate over, and how that information is enumerated.
Microsoft.SqlServer.Dts.Runtime.Interop NamespaceContains members that are used to manage parameters and projects.
Microsoft.SqlServer.Dts.Runtime.Localization NamespaceThe Microsoft.SqlServer.Dts.Runtime.Localization namespace contains the classes used for localization of properties and names in user interfaces.
Microsoft.SqlServer.Dts.Runtime.ReferenceId NamespaceContains class used for the data transformation services runtime reference identifier.
Microsoft.SqlServer.Dts.Runtime.Wrapper NamespaceThe Microsoft.SqlServer.Dts.Runtime.Wrapper namespace provides the classes and interfaces used to create Control Flow components in the runtime. This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll). The classes in this namespace should not be instantiated. Instead, use the classes found in the Microsoft.SqlServer.Dts.Runtime.
Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012 NamespaceThe Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012 namespace provides the classes and interfaces used to create Control Flow components in the runtime. This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll). The classes in this namespace should not be instantiated. Instead, use the classes found in the Microsoft.SqlServer.Dts.Runtime.
Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2014 Namespace
Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2016 Namespace
Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2017 Namespace
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.BulkInsertTask namespace contains the members used by the Bulk Insert Task.
Microsoft.SqlServer.Dts.Tasks.DMQueryTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.DMQueryTask namespace contains the members used by the Data Mining Query task.
Microsoft.SqlServer.Dts.Tasks.DataProfilingTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.DataProfilingTask namespace contains the Integration Services Data Profiling task and supporting classes.
Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask Namespace
Microsoft.SqlServer.Dts.Tasks.ExecuteProcess NamespaceThe Microsoft.SqlServer.Dts.Tasks.ExecuteProcess namespace contains the classes used by the Execute Process task.
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask NamespaceThe ExecuteSQLTask namespace contains the ExecuteSQLTask class that enables a package to run SQL statements. The task can be configured to use result sets, making the results of the SQL statement available to other objects in the package. To use a result set, map the result set to a variable, which can then be used by other objects in the package. The task can also be configured to run parameterized queries. To provide parameter values, map the variables that contain the parameter values to the columns in the query.
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Connections Namespace
Microsoft.SqlServer.Dts.Tasks.ExpressionTask Namespace
Microsoft.SqlServer.Dts.Tasks.FileSystemTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.FileSystemTask namespace contains the classes and interfaces required to manage the file system with the File System task.
Microsoft.SqlServer.Dts.Tasks.FtpTask NamespaceThis namespace contains the members required to create a File Transfer Protocol (FTP) Task.
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask NamespaceThis namespace contains the members required to create a Message Queue task.
Microsoft.SqlServer.Dts.Tasks.ScriptTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.ScriptTask namespace contains the classes that define the Script task and provide support for custom scripting. The ScriptTask class defines the Script task itself. When writing custom script within the Script task, the developer interacts with package objects outside the Script task by using the Dts object, which is an instance of the ScriptObjectModel class.
Microsoft.SqlServer.Dts.Tasks.SendMailTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.SendMailTask namespace contains the SendMailTask class, which enables a package to send e-mail messages.
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask namespace contains classes and enumerations that allow the transfer of databases between a source and a destination server using two different methods: database online, and database offline. The task requires the use of a SMO connection.
Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask allows the transfer error messages from one instance of SQL Server to another.
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferJobsTask namespace contains the classes and enumerations that allow you to copy SQL Server Agent jobs from one instance of SQL Server to another.
Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask namespace contains the classes and enumerations that allow you to copy one or more SQL Server logins from one instance of SQL Server to another.
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask namespace contains the classes that allow you to copy various SQL Server objects from one instance of SQL Server to another.
Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask namespace contains the methods, properties, and enumerations that allow you to copy stored procedures from the master database located on one instance of SQL Server to another.
Microsoft.SqlServer.Dts.Tasks.WebServiceTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.WebServiceTask namespace contains the classes and members used to run a web method and store the results in a specified location.
Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask namespace contains the interfaces and classes used for the WMI Data Reader Task, which uses Windows Management Instrumentation (WMI) to return information about a computer system. For more information about the WMI Data Reader Task, see WMI Data Reader Task.
Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask namespace contains the interfaces and classes used for the WMI Event Watcher Task, which uses Windows Management Instrumentation (WMI) to return information about WMI events that occur on a computer system. For more information about the WMI Event Watcher Task, see WMI Event Watcher Task.
Microsoft.SqlServer.Dts.Tasks.XMLTask NamespaceThe Microsoft.SqlServer.Dts.Tasks.XMLTask namespace contains the interfaces and classes used for the XML Task, which is used to work with XML data. Using this task, a package can retrieve XML documents stored in files, apply operations to the documents using XSL Transformations, (XSLT) style sheets, and XPath expressions, merge multiple documents, and validate, compare, and save the updated documents to files and variables.
Microsoft.SqlServer.Management.IntegrationServices NamespaceThe Microsoft.SqlServer.Management.IntegrationServices namespace contains the classes and interfaces to manage the Integration Services catalog on an instance of SQL Server.
Microsoft.SqlServer.VSTAHosting Namespace
ScriptMigration NamespaceThe ScriptMigration namespace contains the class for the script migration utility.