DtsPipelineComponentAttribute.SupportsBackPressure Propiedad
Identifies the component as one that supports more than one input, and implements the optional methods for handling excessive memory usage if the inputs produce data at uneven rates.
Espacio de nombres: Microsoft.SqlServer.Dts.Pipeline
Ensamblado: Microsoft.SqlServer.PipelineHost (en Microsoft.SqlServer.PipelineHost.dll)
Sintaxis
'Declaración
Public Property SupportsBackPressure As Boolean
Get
Set
'Uso
Dim instance As DtsPipelineComponentAttribute
Dim value As Boolean
value = instance.SupportsBackPressure
instance.SupportsBackPressure = value
public bool SupportsBackPressure { get; set; }
public:
property bool SupportsBackPressure {
bool get ();
void set (bool value);
}
member SupportsBackPressure : bool with get, set
function get SupportsBackPressure () : boolean
function set SupportsBackPressure (value : boolean)
Valor de la propiedad
Tipo: System.Boolean
true if the component supports more than one input and implements the optional methods for handling excessive memory usage if the inputs produce data at uneven rates; otherwise, false.
Comentarios
The first step in implementing better memory management for a custom data flow component that supports multiple inputs is to set the value of the SupportsBackPressure property to true in the T:Microsoft.SqlServer.Dts.Pipeline.DtsPipelineComponentAttribute. When the value of SupportsBackPressure is true, the data flow engine calls the PipelineComponent.IsInputReady method and, when there are more than two inputs, the PipelineComponent.GetDependentInputs method at run time.
For more information about the handling of excessive memory usage if the inputs of a custom data flow component produce data at uneven rates, see Desarrollar componentes de flujo de datos con varias entradas.
Ejemplos
In the following example, the implementation of the DtsPipelineComponentAttribute class sets the value of the SupportsBackPressure property to true.
[DtsPipelineComponent(ComponentType = ComponentType.Transform,
DisplayName = "Shuffler",
Description = "Shuffle the rows from input.",
SupportsBackPressure = true,
LocalizationType = typeof(Localized),
IconResource = "Microsoft.Samples.SqlServer.Dts.MIBPComponent.ico")
]
public class Shuffler : Microsoft.SqlServer.Dts.Pipeline.PipelineComponent
{
...
}