Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

IDTSDesigntimeComponent100.SetUsageType Method

SQL Server 2008

Creates an IDTSInputColumn100 object in the IDTSInputColumnCollection100 of the component and sets the UsageType property of the column.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)
C#
C++
F#
JScript
VB
Copy 
IDTSInputColumn100 SetUsageType(
	int lInputID,
	IDTSVirtualInput100 pIDTSVirtualInputObject,
	int lLineageID,
	DTSUsageType eUsageType
)

Parameters

lInputID
Type: System.Int32
The ID of the IDTSInput100.
pIDTSVirtualInputObject
Type: Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSVirtualInput100
The IDTSVirtualInput100 object that contains the virtual input column and that is used to map the IDTSInputColumn100 object.
lLineageID
Type: System.Int32
The LineageID property of the IDTSVirtualInputColumn100 object.
eUsageType
Type: Microsoft.SqlServer.Dts.Pipeline.Wrapper.DTSUsageType
A value from the DTSUsageType enumeration that is assigned to the IDTSInputColumn100.

SetUsageType is called when a column from the IDTSVirtualInputColumnCollection100 is selected for a component. If the usageType is UT_READONLY or UT_READWRITE, a new input column is created for the component that reflects the IDTSVirtualInputColumn100 specified by the lLineageID parameter. If usageType is UT_IGNORED and the column exists in the collection, the column is removed and null is returned.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ