ScriptComponentHost 类

定义

从托管提供程序中提供记录的 DTS 管道组件。

public ref class ScriptComponentHost : Microsoft::SqlServer::Dts::Pipeline::PipelineComponent, Microsoft::SqlServer::Dts::Pipeline::IVSTAScriptComponentUI
[Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=10, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")]
public class ScriptComponentHost : Microsoft.SqlServer.Dts.Pipeline.PipelineComponent, Microsoft.SqlServer.Dts.Pipeline.IVSTAScriptComponentUI
[Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=11, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")]
public class ScriptComponentHost : Microsoft.SqlServer.Dts.Pipeline.PipelineComponent, Microsoft.SqlServer.Dts.Pipeline.IVSTAScriptComponentUI
[Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=12, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")]
public class ScriptComponentHost : Microsoft.SqlServer.Dts.Pipeline.PipelineComponent, Microsoft.SqlServer.Dts.Pipeline.IVSTAScriptComponentUI
[<Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=10, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")>]
type ScriptComponentHost = class
    inherit PipelineComponent
    interface IVSTAScriptComponentUI
[<Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=11, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")>]
type ScriptComponentHost = class
    inherit PipelineComponent
    interface IVSTAScriptComponentUI
[<Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponent(ComponentType=Microsoft.SqlServer.Dts.Pipeline.ComponentType.Transform, CurrentVersion=12, HelpKeyword="sql13.dts.designer.scriptcomponentdetails.f1", IconResource="Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.ico", LocalizationType=typeof(Microsoft.SqlServer.Dts.Pipeline.Localized), SamplesTag="SsisScriptComponentTransform", UITypeName="Microsoft.DataTransformationServices.DataFlowUI.ScriptUI, Microsoft.DatatransformationServices.DataFlowUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")>]
type ScriptComponentHost = class
    inherit PipelineComponent
    interface IVSTAScriptComponentUI
Public Class ScriptComponentHost
Inherits PipelineComponent
Implements IVSTAScriptComponentUI
继承
ScriptComponentHost
属性
实现

构造函数

ScriptComponentHost()

属性

BufferManager

获取管道组件的 IDTSBufferManager100

(继承自 PipelineComponent)
ComponentMetaData

获取组件的 IDTSComponentMetaData100

(继承自 PipelineComponent)
CurrentScriptingEngine
ErrorSupport

返回一个 ErrorSupport 对象,该对象使组件可以基于由以本机代码编写的 Integration Services 组件返回的 hresult,引发错误、警告或其他信息事件。

(继承自 PipelineComponent)
EventInfos

获取 IDTSEventInfos100 对象的 PipelineComponent 集合。

(继承自 PipelineComponent)
LogEntryInfos

获取组件已注册的日志记录事件的 IDTSLogEntryInfos100 集合。

(继承自 PipelineComponent)
ProjectTemplatePath
ReferenceTracker

获取与组件关联的 IDTSObjectReferenceTracker100

(继承自 PipelineComponent)
VariableDispenser

获取数据流组件的 IDTSVariableDispenser100

(继承自 PipelineComponent)

方法

AcquireConnections(Object)
AddErrorOutput(String, Int32, Int32)

IDTSOutput100通过将对象的属性设置为 true,添加一个对象并将其标记为错误输出 IsErrorOut

(继承自 PipelineComponent)
Cleanup()
CloseIDE()
CreateNewProject(String, Boolean, Boolean)
DeleteExternalMetadataColumn(Int32, Int32)

从外部元数据列的集合中删除指定索引处的外部元数据列。

(继承自 PipelineComponent)
DeleteInput(Int32)

IDTSInput100 集合中删除 IDTSInputCollection100 对象。

(继承自 PipelineComponent)
DeleteOutput(Int32)

IDTSOutput100 集合中删除 IDTSOutputCollection100 对象。

(继承自 PipelineComponent)
DeleteOutputColumn(Int32, Int32)

IDTSOutputColumn100 集合中删除 IDTSOutputColumnCollection100 对象。

(继承自 PipelineComponent)
DescribeRedirectedErrorCode(Int32)

为添加到输出缓冲区的 PipelineBuffer 行提供错误代码信息。

(继承自 PipelineComponent)
GetBinaryCode(String)
GetDependentInputs(Int32)

返回正在等待更多数据的输入 ID 的集合,并且因此阻塞指定的输入。

(继承自 PipelineComponent)
GetErrorOutputInfo(Int32, Int32)

返回组件的错误输出的索引和 ID。

(继承自 PipelineComponent)
GetUniqueVSTAProjectName()
Initialize()

当在派生类中重写时,初始化自定义数据流组件的新实例。

(继承自 PipelineComponent)
InsertExternalMetadataColumnAt(Int32, Int32, String, String)

将新的外部元数据列插入到位于指定索引处的外部元数据列的集合中。

(继承自 PipelineComponent)
InsertInput(DTSInsertPlacement, Int32)
InsertOutput(DTSInsertPlacement, Int32)
InsertOutputColumnAt(Int32, Int32, String, String)
IsInputReady(Int32[], Boolean[])

确定附加到某个组件的哪些输入正在等待更多数据,并且确定哪些输入具有可供处理的足够数据和被阻塞。

(继承自 PipelineComponent)
LoadScriptFromComponent()

从组件自定义属性集合中加载脚本代码和二进制文件并将其放入脚本存储

MapInputColumn(Int32, Int32, Int32)

在输入列与相应的外部元数据列之间建立关系。

(继承自 PipelineComponent)
MapOutputColumn(Int32, Int32, Int32, Boolean)

在输出列与相应的外部元数据列之间建立关系。

(继承自 PipelineComponent)
OnDeletingInputColumn(Int32, Int32)

IDTSInputColumn100 中删除一个 IDTSInputColumnCollection100 对象。

(继承自 PipelineComponent)
OnInputPathAttached(Int32)

IDTSInput100 对象通过 IDTSPath100 接口连接到组件时调用。

(继承自 PipelineComponent)
OnInputPathDetached(Int32)

IDTSInput100 对象通过 IDTSPath100 接口与组件断开连接时调用。

(继承自 PipelineComponent)
OnOutputPathAttached(Int32)

当组件的 IDTSOutput100 对象附加到下游组件时调用。

(继承自 PipelineComponent)
PerformDowngrade(Int32, DTSTargetServerVersion)
PerformUpgrade(Int32)
PostExecute()
PreExecute()
PrepareForExecute()
PrimeOutput(Int32, Int32[], PipelineBuffer[])
ProcessInput(Int32, PipelineBuffer)
ProvideComponentProperties()
PutBinaryCode(String, Byte[])
PutSourceCode(String, String, String)
RegisterEvents()

当您正在开发一个自定义数据流组件时,您重写此方法以创建自定义事件。

(继承自 PipelineComponent)
RegisterLogEntries()
ReinitializeMetaData()

修复在验证过程中确定的导致组件在设计时返回 VS_NEEDSNEWMETADATA 的任何错误。

(继承自 PipelineComponent)
ReleaseConnections()
RemoveAllInputsOutputsAndCustomProperties()

从组件中删除每个 IDTSInput100IDTSOutput100 对象。

(继承自 PipelineComponent)
SaveScriptProject()
SetComponentProperty(String, Object)
SetExternalMetadataColumnDataTypeProperties(Int32, Int32, DataType, Int32, Int32, Int32, Int32)

设置指定外部元数据列的数据类型属性。

(继承自 PipelineComponent)
SetExternalMetadataColumnProperty(Int32, Int32, String, Object)

设置外部元数据列的单个属性。

(继承自 PipelineComponent)
SetInputColumnProperty(Int32, Int32, String, Object)

IDTSCustomProperty100 对象的 IDTSInputColumn100 赋值。

(继承自 PipelineComponent)
SetInputProperty(Int32, String, Object)

IDTSCustomProperty100 对象的 IDTSInput100 赋值。

(继承自 PipelineComponent)
SetOutputColumnDataTypeProperties(Int32, Int32, DataType, Int32, Int32, Int32, Int32)
SetOutputColumnProperty(Int32, Int32, String, Object)

设置 IDTSCustomProperty100 对象的 IDTSOutputColumn100 的值。

(继承自 PipelineComponent)
SetOutputProperty(Int32, String, Object)

设置 IDTSCustomProperty100 对象的 IDTSOutput100 的值。

(继承自 PipelineComponent)
SetUsageType(Int32, IDTSVirtualInput100, Int32, DTSUsageType)

在组件的 IDTSInputColumn100 中创建一个 IDTSInputColumnCollection100 对象,并设置该列的 UsageType 属性。

(继承自 PipelineComponent)
ShowIDE()
Validate()

适用于