DTS and Log File

Ok, I have a problem that maybe easy to solve because of my inexperience but it sure is baffling. I am trying to load a text file into a table on SQL server. This file is around 635 meg. When I try to load it through a DTS it will run through all the rows (1228000). Then it will hang for a while then I will get a execution failure saying that the log file is full. Then it will tell you to backup the log file and blah blah blah. Problem is I do this and then try again and get the same problem. As a matter of fact the second time I tried it told me the tempdb log file was full. Any ideas? I have the log file for the database set to expand as needed.

Thanks
TomI'm thinking it is the DTS log file rather than the Database

http://vyaskn.tripod.com/sql_server_dts_error_file.htm