Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 import a row larger 8000 characters

Author  Topic 

melly
Starting Member

1 Post

Posted - 2006-09-13 : 15:58:32
I am trying to import a file where my row size is larger than the 8000 characters. My rows are about 10300 in size where about 10,200 of the those characters all come from one column in one word.

How do I go about importing such a large file?

I tried to change the datatype to ntext but it just cut off some of the data.

Any help would be appreaciated.

Melanie

iminore
Posting Yak Master

141 Posts

Posted - 2006-09-14 : 10:19:14
Have you read about WRITETEXT in BOL?
Go to Top of Page
   

- Advertisement -