sql server 2008 - SSIS: Remove Empty Row from outputbuffer -

i have error on data flow task.

i have ado.net source going async script component.

the problem comes @ end of insert script component destination

tries put empty row automatically puts in output buffer in table.

is there way prevent happening/ how can manipulate output buffer can remove specific rows it?

you source goes async script component. if true, controlling when rows go output buffer.

by default, script component synchronous. there 1 output row each input row. maybe have setup.

if want use script component asynchronous component, have following:

• add new script component
• right-click on component , select show advanced editor...
• on input , output properties, select output item , change synchronousinputid value none
• on output tab, add columns define output buffer. must define columns because, unlike synchronous script, output buffer not automatically defined match input buffer.

when edit script, can use outputbuffer.addrow method create new rows in output buffer. each time call addrow, existing buffer content sent out of script component , cleared next row. using rules skipping rows, validate input buffer before adding or skipping row.