Microsoft.SqlServer.Management.IntegrationServices Namespace

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

Classes

Catalog

Represents an Integration Services database.

Catalog.Key

Represents the key used to access the Catalog class.

CatalogCollection

Represents the collection for catalogs.

CatalogFolder

Represents the folder for the catalogs.

CatalogFolder.Key

Represents the key used to access the CatalogFolder class.

CatalogFolderCollection

Represents the collection for catalog folders.

CustomizedLoggingLevel
CustomizedLoggingLevel.Key
CustomizedLoggingLevelCollection
CustomLoggingLevel
CustomLoggingLevelType
EffectivePermissionInfo

Describes one permission entry in explicit list of permission of an object.

EnableSsisSupportAlwaysOnSqmHelper
EnvironmentCollection

Represents the collection for environments.

EnvironmentInfo

Represents the information for an environment.

EnvironmentInfo.Key

Represents the key used to access the EnvironmentInfo class.

EnvironmentReference

Represents the reference for an environment.

EnvironmentReference.Key

Gets the key used to access the EnvironmentReference class.

EnvironmentReferenceCollection

Represents the collection for environment references.

EnvironmentVariable

Represents the variable for an environment.

EnvironmentVariable.Key

Represents the key used to access the EnvironmentVariable class.

EnvironmentVariableCollection

Represents the collection for environment variables.

ExecutionOperation

Represents a class for an ExecutionOperation.

ExecutionOperation.Key

Represents the key used to access the ExecutionOperation class.

ExecutionOperationCollection

Provides the collection for the operation messages.

ExplicitPermissionInfo

Describes one permission entry in explicit list of permissions of an object.

IdKey

Represents a class that is used to identify the object which has “Id” property as the key.

IntegrationServices

Represents the root of the Integration Services.

IntegrationServices.Key

Represents the domain root key for the Integration Services.

IntegrationServicesException

Represents the base class for all Integration Services exceptions.

ListDropDownEditor
LoggingTypeConverted
NameKey

Identifies NameKey object which has name property as the key.

Operation

Represents the class for an operation.

Operation.Key

Represents a key class for identification.

OperationCollection

Represents a collection for operation messages.

OperationMessage

Represents a class for an operation message.

OperationMessage.Key

Represents the key used to access the OperationMessage class.

OperationMessageCollection

Represents the collection for operation messages.

PackageCollection

Represents a collection of package.

PackageInfo

Represents a class for package information.

PackageInfo.ExecutionValueParameterSet

Represents the set of the execution value parameter.

PackageInfo.Key

Represents the key used to access the instance.

PackageInfo.PropertyOverrideParameterSet

Represents the set of property override parameters.

ParameterCollection

This is the collection for Folders.

ParameterInfo

Class for a parameter.

ParameterInfo.Key

The key used to access the instance.

ProjectCollection

Represents the collection for ProjectInfos.

ProjectInfo

Represents a class for a project.

ProjectInfo.Key

Represents the key used to access the catalog.

ProjectVersion

Represents a class for a project version.

ProjectVersion.Key

Represents a class used to identify the object which have “Name” property as the key.

ProjectVersionCollection

Represents the collection for project versions.

ReplicaDataInfo

The information of the replica

Utilities
ValidationOperation

Represents the class for a ValidationOperation.

ValidationOperation.Key

Represents the key used to access the ValidationOperation class.

ValidationOperationCollection

Provides the collection for the operation messages.

Enums

Catalog.Encryption

Specifies the encryption algorithm that is used for the catalog.

Catalog.ExecutionMode

Package execution mode.

Catalog.LoggingLevelType

Specifies the logging level type.

EnableExceptionType
EnableResult
EnvironmentReference.ReferenceLocationType

Specifies if the reference location is an absolute folder name or the local folder that the project is in.

Operation.ServerOperationStatus

Specifies the server operation status.

PackageInfo.ReferenceUsage

Represents the reference usage of the PackageInfo.

ParameterInfo.ParameterValueType

Indicates the parameter value type: literal value or referenced variable name.

PermissionType

Represents a user’s permissions.

PrincipalType

Specifies the principal types.

ProjectInfo.ReferenceUsage

Represents the reference usage for the ProjectInfo.

SecurableType

Specifies the securable type for the Integration Services (SSIS).

Utilities.AlwaysOnNodeType

The AlwaysOn node type