Hi, We are using SQL Server 2014 database and SSIS to load data to tables and the volume of data to load would vary from 2 million records to 17 million records and while I was working on loading data to a table approx. 6 million records I run into this error every once in while "transaction log for database is full due to ACTIVE_TRANSACTION".
The database is in Simple Recovery mode and not exactly sure what would cause this? What approach should I be taking to free up the transaction log from time to time.
As a work around to fix this issue I tried using checkpoint and even this did not help resolve this issue.
Thanks in advance..............