MS SQL Server Database Option - Transaction Log
The transaction record not important because I can retrieve from my source again if needed.
. . .
What database recovery mode should I set

SIMPLE.  Then shrink the log one time.