I have a data flow task that calls an update SP via OLE DB COMMAND for each row (the rows are obtained from an OLE DB SOURCE). if the update SP fails in one row for some reason I need to resume next and commit the other updates performed. I have >
100 rows, in the logs I have only one error but looks like no updates get committed. I have set max no of errors to 0, set component not transactional but nothing seems to work.
Is this possible or is a limitation in the dataflow?
View Complete Post