• Article

Microsoft.SqlServer.Dts.Pipeline Namespace

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.

Classes

  Class Description
Public class BlobColumn Defines a column in a data flow buffer that contains data that has a SQL Server data type of text, ntext, or image.
Public class BufferDisconnectedException The exception that is thrown when an attempt to access a PipelineBuffer object fails.
Public class BufferNotFoundException The exception that is thrown when a PipelineBuffer is not found.
Public class CannotCreatePipelineComponentException The exception that is thrown when the data flow cannot create an instance of a Script component.
Public class CannotCreateUserComponentException Exception thrown when the Script component cannot instantiate the class that contains the custom code that the developer creates in the Script component. The class is named ScriptMain by default.
Public class ColumnIndexOutOfRangeException The exception that is thrown when an attempt to access a buffer column by using an index is outside the bounds of the collection of buffer columns.
Public class ColumnIsNullException The exception that is thrown when using a specific data type column access method and the column value is null.
Public class ComponentUpgradeFailedException The exception that is thrown when the PerformUpgrade method of a component fails.
Public class ComponentVersionMismatchException The exception that is thrown when the component version stored in the package XML is higher than the version of the component installed on the current computer.
Public class DoesNotFitBufferException The exception that is thrown when a value that is too large to fit in the data area of a BufferColumn is written to the buffer.
Public class DtsPipelineComponentAttribute Contains design-time information about a PipelineComponent object.
Public class InputNotFoundException The exception that is thrown when the Script Component is unable to find an IDTSInput100 object defined internally by the component.
Public class ManagedComponentHost Infrastructure.
Public class NoCurrentRowException The exception that is thrown when the address of the beginning of a PipelineBuffer row is null.
Public class NotOutputBufferException The exception that is thrown when a method that is restricted to Output objects is called on an InputPipelineBuffer.
Public class OutputNotFoundException The exception that is thrown by the ScriptComponent when an IDTSOutput100 cannot be found in its IDTSOutputColumnCollection100.
Public class PipelineBuffer Provides an in-memory data store containing rows and columns of data.
Public class PipelineComponent Defines the base class that is used when developing managed data flow components.
Public class PipelineComponentHResultException Exception raised by the Script component when it encounters a COM exception.
Public class ReadOnlyVariablesNotAvailableException Exception raised by the Script component when the ReadOnlyVariables collection is not available.
Public class ReadWriteVariablesNotAvailableException Exception raised by the Script component when the ReadWriteVariables collection is not available.
Public class RowIndexOutOfRangeException The exception that is thrown when an invalid index is supplied when accessing a row in a PipelineBuffer.
Public class ScriptBuffer Serves as the base class for the read-only classes representing the input and the outputs that are generated by the Script component in the BufferWrapper project item in a Script component project.
Public class ScriptComponent Serves as the base class for the read-only UserComponent class generated by the Script component in the ComponentWrapper project item in a Script component project.
Public class ScriptComponentHost Infrastructure.
Public class ScriptingLanguageNotFoundException The exception that is thrown by the Script component when the scripting language is not found.
Public class SSISScriptComponentEntryPointAttribute Infrastructure.
Public class UnsupportedBufferDataTypeException The exception that is thrown when assigning a value to a buffer column that contains the incorrect data type.
Public class UnsupportedDataRecordTypeException The exception that is thrown when an unsupported parameter value is passed to the DataRecordTypeToBufferType method.
Public class UnsupportedValueTypeForTextStreamColumnException The exception that is thrown when the type of the value that is being assigned to a column in a PipelineBuffer is not a string or byte array.
Public class VSTAComponentScriptingEngine Infrastructure.

Structures

  Structure Description
Public structure BufferColumn Provides read-only metadata for a PipelineBuffer column.

Interfaces

  Interface Description
Public interface IVSTAScriptComponentUI Infrastructure.

Enumerations

  Enumeration Description
Public enumeration ComponentType Specifies the three types of data flow components.
Public enumeration PipelineBufferMode Contains values used to identify a PipelineBuffer as an input or output buffer.