Been trouble shooting for weeks a major performance decline across 100 packages migrating very large tables. Discovered the packages where inserting row-by-row and not bulked any more. The ADO.Net Destination CM has 'Use Bulk Insert when possible' ticked - but has decided not to bulk insert any more.
Does anyone know the criteria that determines whether ADO.Net Destination will BULK INSERT or Row-by-Row? I'm unable to find any articles out there for an explanation what the 'where possible' means!?!?
Thanks in advance