Integration Services Reference

 

NamespaceDescription
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask

The 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.SqlServer.Dts.Design

The 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

The 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

The 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

The 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

The 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

The 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

The 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

Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2014

Microsoft.SqlServer.Dts.Runtime

The 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

The 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

The 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

The 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

The 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

The 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

The 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

Contains members that are used to manage parameters and projects.

Microsoft.SqlServer.Dts.Runtime.Localization

The Microsoft.SqlServer.Dts.Runtime.Localization namespace contains the classes used for localization of properties and names in user interfaces.

Microsoft.SqlServer.Dts.Runtime.ReferenceId

Contains class used for the data transformation services runtime reference identifier.

Microsoft.SqlServer.Dts.Runtime.Wrapper

The 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

Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2014

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask

The Microsoft.SqlServer.Dts.Tasks.BulkInsertTask namespace contains the members used by the Bulk Insert Task.

Microsoft.SqlServer.Dts.Tasks.DataProfilingTask

The Microsoft.SqlServer.Dts.Tasks.DataProfilingTask namespace contains the Integration Services Data Profiling task and supporting classes.

Microsoft.SqlServer.Dts.Tasks.DMQueryTask

The Microsoft.SqlServer.Dts.Tasks.DMQueryTask namespace contains the members used by the Data Mining Query task.

Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask

Microsoft.SqlServer.Dts.Tasks.ExecuteProcess

The Microsoft.SqlServer.Dts.Tasks.ExecuteProcess namespace contains the classes used by the Execute Process task.

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask

The 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.ExpressionTask

Microsoft.SqlServer.Dts.Tasks.FileSystemTask

The 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

This namespace contains the members required to create a File Transfer Protocol (FTP) Task.

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask

This namespace contains the members required to create a Message Queue task.

Microsoft.SqlServer.Dts.Tasks.ScriptTask

The 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

The Microsoft.SqlServer.Dts.Tasks.SendMailTask namespace contains the SendMailTask class, which enables a package to send e-mail messages.

Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask

The 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

The Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask allows the transfer error messages from one instance of SQL Server to another.

Microsoft.SqlServer.Dts.Tasks.TransferJobsTask

The 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

The 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

The 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

The 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

The 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

The 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

The 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

The 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

The Microsoft.SqlServer.Management.IntegrationServices namespace contains the classes and interfaces to manage the Integration Services catalog on an instance of SQL Server.

ScriptMigration

This API supports the product infrastructure and is not intended to be used directly from your code. The ScriptMigration namespace contains the class for the script migration utility.

Return to top
Show: