importing from large text files

• Robert Stewart-151824

  Newbie

  Points: 2

  More actions

  June 17, 2004 at 9:50 am

  #59267

  I have tried to use the DTS wizard to import a very large text file into a table of the form tbl(a tinyint, b text).  The bulk of the data from the file is going in the text fields.  Some of the rows in the file are under 1MB long and these import just fine.  But the rows that are over 1MB long (some are as large as 200MB) won't import correctly.  If I format the file to be delimited, the larger rows won't load at all.  If I use fixed field, the rows get truncated at 8KB.  According to the sql doc, text fields can hold up to 2GB of data, so in theory I should be able to import the text file.  Any suggestions?

  Thanks!     

• June 21, 2004 at 8:00 am

  This was removed by the editor as SPAM

• rstack

  SSC Journeyman

  Points: 99

  More actions

  June 23, 2004 at 10:19 am

  #511646

  Check this topic out in SQL Server Books Online - Managing ntext, text, and image Data. Not sure about implementing this with the DTS wizard.