Export (0) Print
Expand All

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 IDTSBuffer90 interface. The PipelineBuffer class marshals data flow buffers between the COM data flow engine and managed data flow components.

ClassDescription
BlobColumnDefines a column in a data flow buffer that contains data that has a SQL Server data type of text, ntext, or image.
BufferDisconnectedExceptionThe exception that is thrown when an attempt to access a PipelineBuffer object fails.
BufferNotFoundExceptionThe exception that is thrown when a PipelineBuffer is not found.
CannotCreatePipelineComponentExceptionThe exception that is thrown when the data flow cannot create an instance of a Script component.
CannotCreateUserComponentExceptionException 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.
ColumnIndexOutOfRangeExceptionThe 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.
ColumnIsNullExceptionThe exception that is thrown when using a specific data type column access method and the column value is null.
ComponentUpgradeFailedExceptionThe exception that is thrown when the PerformUpgrade method of a component fails.
ComponentVersionMismatchExceptionThe 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.
DoesNotFitBufferExceptionThe 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.
DtsPipelineComponentAttributeContains design-time information about a PipelineComponent object.
InputNotFoundExceptionThe exception that is thrown when the Script Component is unable to find an IDTSInput90 object defined internally by the component.
ManagedComponentHost 
NoCurrentRowExceptionThe exception that is thrown when the address of the beginning of a PipelineBuffer row is null.
NotOutputBufferExceptionThe exception that is thrown when a method that is restricted to Output objects is called on an InputPipelineBuffer.
OutputNotFoundExceptionThe exception that is thrown by the ScriptComponent when an IDTSOutput90 cannot be found in its IDTSOutputColumnCollection90.
PipelineBufferProvides an in-memory data store containing rows and columns of data.
PipelineComponentDefines the base class that is used when developing managed data flow components.
PipelineComponentHResultExceptionException raised by the Script component when it encounters a COM exception.
ReadOnlyVariablesNotAvailableExceptionException raised by the Script component when the ReadOnlyVariables collection is not available.
ReadWriteVariablesNotAvailableExceptionException raised by the Script component when the ReadWriteVariables collection is not available.
RowIndexOutOfRangeExceptionThe exception that is thrown when an invalid index is supplied when accessing a row in a PipelineBuffer.
ScriptBufferServes 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.
ScriptComponentServes 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.
ScriptComponentHost 
ScriptDesignTime 
UnsupportedBufferDataTypeExceptionThe exception that is thrown when assigning a value to a buffer column that contains the incorrect data type.
UnsupportedValueTypeForTextStreamColumnExceptionThe exception that is thrown when the value of the type that is being assigned to a column in a PipelineBuffer is not a string or byte array.

InterfaceDescription
IScriptComponentUI 

StructureDescription
BufferColumnProvides read-only metadata for a PipelineBuffer column.This structure is not CLS-compliant.

EnumerationDescription
ComponentTypeSpecifies the three types of data flow components.
PipelineBufferModeContains values used to identify a PipelineBuffer as an input or output buffer.

Community Additions

ADD
Show:
© 2014 Microsoft