Incase of error skip that row in Dataflow

hi all

i need insert 10 records in destination using dataflow.

now issue in case if there error @ row1 jump next row .

my query ;

select top 10 * table1

please me how can skip error row.

please me resolve issue.

thanks & regards

bi_group

in destination first set max commit size , max insert size 50000. drag error redirection ole db destination values of 10000 each. drag error redirection of task ole db destination both values of 1 each. connect ole db destination gather error column.

this way can obtain redirect single error row , allow processing.

---

regards,
karthik

please remember click mark answer , vote helpful on posts you. can beneficial other community members reading thread.

SQL Server  >  SQL Server Integration Services