DTS -Issue, Very Strange

• SQL DBA3

  Grasshopper

  Points: 15

  More actions

  November 22, 2005 at 7:04 pm

  #152633

  I'm importing data by DTS &the source files are text files, I'm experience very strange issue -

  I have impotred 5 data files into the database successfully & (each file has 20,000 records). I was importing the sixth data file(txt) which has also 20000 records, but I got the folllowing error message after I completed the DTS,

  "Not enough storage is available to complete this operation"

  And I found out from Microsoft site http://support.microsoft.com/kb/889170 that this error 'Not enough storage is available to complete this operation', is a BUG in MS SQL Server & MSFT confirmed it.

  But my concern is why din't I get the error while importing the five fles?  I see no difference in any files just data, all are (txt) files. I  got this error while importing the sixth (txt) file. Now I need to Import other files but I get the above mentioned error!

  Any Suggestions would be appreciated!

  Thank you!

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  November 22, 2005 at 8:29 pm

  #605384

  Hi,

  Do ur 6th text file has a date field or binary text.

  HTH

  from

  Killer