I have a B2B map that has advanced database as the target. There is header table that will have one entry in it and a detail table that will have an entry for each line in the source file. In the header table there is a status column being set that a database event is looking for. I don’t want the database event to trigger until all the records in the detail table are done committing. The potential issue is that the sources files can be as big as 70,000 rows.
Selecting the "Use Parent/Child DataSet" Advanced property, the value of commit count will be decided only on the basis of the number of parent records. So in this case, the header or multiple detail records will be considered as only one record. The commit count could be decided on the total number of record and the database that can accommodate the number of records that are committed.