Interface IDTSDesigntimeComponent100

Defines the design-time methods of a data flow component written in C++ and COM.

Espace de noms :  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly :  Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntaxe

'Déclaration
<GuidAttribute("FF5DD3F1-99C1-4FFB-B097-1B1B2B9E9B2D")> _
Public Interface IDTSDesigntimeComponent100
'Utilisation
Dim instance As IDTSDesigntimeComponent100
[GuidAttribute("FF5DD3F1-99C1-4FFB-B097-1B1B2B9E9B2D")]
public interface IDTSDesigntimeComponent100
[GuidAttribute(L"FF5DD3F1-99C1-4FFB-B097-1B1B2B9E9B2D")]
public interface class IDTSDesigntimeComponent100
[<GuidAttribute("FF5DD3F1-99C1-4FFB-B097-1B1B2B9E9B2D")>]
type IDTSDesigntimeComponent100 =  interface end
public interface IDTSDesigntimeComponent100

Le type IDTSDesigntimeComponent100 expose les membres suivants.

Méthodes

  Nom Description
Méthode publique AcquireConnections Establishes a connection to a connection manager.
Méthode publique DeleteExternalMetadataColumn Deletes the external metadata column at the specified index from the collection of external metadata columns.
Méthode publique DeleteInput Deletes an IDTSInput100 object from the IDTSInputCollection100 collection.
Méthode publique DeleteOutput Deletes an IDTSOutput100 object from the IDTSOutputCollection100 collection.
Méthode publique DeleteOutputColumn Deletes an IDTSOutputColumn100 object from the IDTSOutputColumnCollection100 collection.
Méthode publique DescribeRedirectedErrorCode Returns the description of the specified error code.
Méthode publique GetEnumerationCollection Returns the IDTSFriendlyEnumCollection100 of a component.
Méthode publique InsertExternalMetadataColumnAt Inserts a new external metadata column into the collection of external metadata columns at the specified index.
Méthode publique InsertInput Adds an IDTSInput100 object to the IDTSInputCollection100.
Méthode publique InsertOutput Adds a new IDTSOutput100 object.
Méthode publique InsertOutputColumnAt Creates a new IDTSOutputColumn100 object and inserts it into the IDTSOutputColumnCollection100.
Méthode publique MapInputColumn Establishes a relationship between an input column and a corresponding external metadata column.
Méthode publique MapOutputColumn Establishes a relationship between an output column and a corresponding external metadata column.
Méthode publique OnDeletingInputColumn Called when deleting an IDTSInputColumn100 object from the IDTSInputColumnCollection100.
Méthode publique OnInputPathAttached Called when an IDTSInput100 object is connected to another component through the IDTSPath100 interface.
Méthode publique OnInputPathDetached Called when an IDTSPath100 object that contains the specified IDTSInput100 object is deleted.
Méthode publique OnOutputPathAttached Called when an IDTSOutput100 object of the component is attached to a downstream component.
Méthode publique ProvideComponentProperties Initializes the ComponentMetaData of the component when a component is first added to the data flow task.
Méthode publique ReinitializeMetaData Fixes any errors identified during design-time validation that result in the component returning VS_NEEDSNEWMETADATA.
Méthode publique ReleaseConnections Frees the connections established during AcquireConnections at either design time or run time.
Méthode publique SetComponentProperty Assigns a value to an IDTSCustomProperty100 of a component.
Méthode publique SetExternalMetadataColumnDataTypeProperties Sets the data type properties of the specified external metadata column.
Méthode publique SetExternalMetadataColumnProperty Sets an individual property of an external metadata column.
Méthode publique SetInputColumnProperty Assigns a value to the IDTSCustomProperty100 of an IDTSInputColumn100 object.
Méthode publique SetInputProperty Assigns a value to the IDTSCustomProperty100 of an IDTSInput100 object.
Méthode publique SetOutputColumnDataTypeProperties Sets the data type properties of an IDTSOutputColumn100 object.
Méthode publique SetOutputColumnProperty Sets the value of an IDTSCustomProperty100 for an IDTSOutputColumn100 object.
Méthode publique SetOutputProperty Sets the value of an IDTSCustomProperty100 for an IDTSOutput100 object.
Méthode publique SetUsageType Creates an IDTSInputColumn100 object in the IDTSInputColumnCollection100 of the component and sets the UsageType property of the column.
Méthode publique Validate Verifies that the component is correctly configured.

Haut de la page

Notes

This interface is one of two interfaces implemented by data flow components; IDTSRuntimeComponent100 is the other. This interface defines the design-time interface for a component and contains methods that are called when the component properties and collections of the ComponentMetaData are modified. Managed component developers do not explicitly implement this interface, and instead use the PipelineComponent base class, which implements the methods of both these interfaces.

When programmatically adding or modifying existing components in a data flow task, the design-time instance of a component should be used instead of accessing the component metadata directly. Modifying the ComponentMetaData directly bypasses the ability of the component to validate and reject changes to its metadata, and should be avoided. Managed code developers access the design-time instance of a component, and use the methods of the IDTSDesigntimeComponent100 interface, through the CManagedComponentWrapper.

Exemples

The following code example demonstrates how to access the design-time instance of a component.

Package p = new Package();
MainPipe dataFlow = ((TaskHost)p.Executables.Add("DTS.Pipeline")).InnerObject as MainPipe;

IDTSComponentMetaData100 md = dataFlow.ComponentMetaDataCollection.New();
md.ComponentClassID = "DTSAdapter.OleDbSource";
CManagedComponentWrapper wrp = md.Instantiate();
wrp.ProvideComponentProperties();
Dim p As Package = New Package 
Dim dataFlow As MainPipe = CType(CType(p.Executables.Add("DTS.Pipeline"), TaskHost).InnerObject, MainPipe) 
Dim md As IDTSComponentMetaData100 = dataFlow.ComponentMetaDataCollection.New 
md.ComponentClassID = "DTSAdapter.OleDbSource" 
Dim wrp As CManagedComponentWrapper = md.Instantiate 
wrp.ProvideComponentProperties

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Pipeline.Wrapper