I am trying to use DTS in SQL Server 2000 to transfer 6.5 million records (8 to 9 Gig of data). In doing this, every time it gets to the end it say the transaction log is full and cannot complete the transfer. I really don't care about the log. I just need to transfer the data. What steps do I need to take in setting up the database so that the log file is not affected by the transfer? So far I have uncheck auto grow log and set recovery model to simple. I appreciate the help.
Randy Belcher
AFG Industries, Inc.