Is this a bulk insert ?

If this is a bulk insert, you can make minimal transaction logging by changing the database option to bulk logged .

Once when you are done with...

Do you guys do any back up? if so, shrink the log file using DBCC_SHRINKFILE

or

after the execution by the com processs, shrink the log file manually either by using...

 use the following statement in the stored procedure

exec dtsrun /S<servername> /U<username> /P<password> /N<packagename>