June 17, 2004 at 9:50 am
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
June 23, 2004 at 10:19 am
Check this topic out in SQL Server Books Online - Managing ntext, text, and image Data. Not sure about implementing this with the DTS wizard.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply