Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    16

    Unanswered: 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
    Tom

  2. #2
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95

    Arrow

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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •