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

Posted by Rick on Stack Overflow See other posts from Stack Overflow or by Rick
Published on 2010-05-04T21:51:25Z Indexed on 2010/05/04 21:58 UTC
Read the original article Hit count: 390

Filed under:

ssis-data-tranformations

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 posts about ssis-data-tranformations

SSIS how to split a single record in to two different records?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Product record that has multiple "zoned" prices, one for each store that sells the product. ProductID int Name string PriceA money PriceB money PriceC money In SQL Server Integration Services, I need to split this in to multiple records: ProductID int Version string //… >>> More
script component

as seen on Stack Overflow - Search for 'Stack Overflow'
what is the use of script component in Data Flow ? Is it same as Script Task in Control flow ? Any difference ? >>> More
Error in retrieving data from Excel File

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an excel file. I wanted to pull the data from excel file to SQL Server table. And the data is successfully transferred.In the excel file, I removed a text from one column named "Risk" from one row.The text was lengthy one.now the package execution fails at the source ie from the excel file… >>> More
Script Task - File Manipulation

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Script Task, I have written a code to create a folder and create a file of msword document inside the created folder. Its working in local machine. But its not working in another server, after I deployed it. The folder is created successfully, but the word document file is not created. for word… >>> More
How can we abort the post in ProcessInputRow() event in SQL SSIS Script Component?

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More

Developer IT

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

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

ssis-data-tranformations

Related posts about ssis-data-tranformations

SSIS how to split a single record in to two different records?

script component

Error in retrieving data from Excel File

Script Task - File Manipulation

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

Categories cloud