Shrink SQL Server Log File
These instructions detail how to shrink a SQL Server Log File.
I. Shrink the log file size at the right time
Immediately after using the SSIS package or Import the data to the database ( highlight the database->Tasks->Import data … ), or Export the data from the database ( highlight the database->Tasks->Export data … ), shrink the log file to the desired size, for example, 1MB. That is, highlight the database->Tasks->Shrink->Files
Then, click OK and you are done.
Other SQL Server Solutions to Consider
Truncate SQL Server Log Overview
II. Eliminate SQL Server Log Instructions