tags:

views:

43

answers:

0
Q: 

How can we abort the post in ProcessInputRow() event in SQL SSIS Script Component?

How can we abort the table post in this event: public override void Input0_ProcessInputRow(Input0Buffer Row) ... based on an input table field condition in our SSIS Script Component?

For example if(Row.BoolValue) AbortPost();

We don't want to abort the whole process just this one record post. This is one record from the input table we don't want in the output table.

related questions

Performance difference - Script Task
blank to numeric conversion derived column
Import Excel data to SQL Server
SSIS Lookup component only returns matching rows when using partial mode
Return dataset in dataflow
timestamp in C#
Use SSIS to import binary data in XML file
Error in retrieving data from Excel File
How to get 2 data sources to merge in SSIS?
execute SSIS package
Store Dataset to DTS Variable
About Script Task
Script Task - File Manipulation
SSIS how to split a single record in to two different records?
Script Task - Add Reference Issue
Tool for generating flat files from SQL objects dynamically
SQL Server 2008 - Script Data as Insert Statements from SSIS Package
Lookup Transformation Task
Using SSIS to import a CSV File.
What is SSIS order of data transformation component method calls
The version of component "x" is not compatible with this version of the DataFlow.
SQL Server Integration Services SSIS 2005 - How do I see all the rows in a data viewer?
Producing a revenue forecast in SQL
SSIS - Change Null columns to empty strings