Yesterday, the leader said. You need to import a TXT file into the MS SQL Server 2000. There are 812 lines in Colum. When I write the DTS of SQL Server, an error occurs when I execute. Say the value of the insert is greater than 8060. It is not necessary to exceed this value when it is called DTS conversion. Then I naturally think of being imported twice, once is INSERT and in Update. But I am not familiar with DTS. I found a few articles on the Internet. Suddenly thought of the problem of SQL Sever. Then built a table TEST in the database
Table test
ID INT 4
Context1 Varchar 4000;
CONTEXT2 VARCHAR 4000;
CONTEXT3 VARCHAR 4000;
Then I first recorded 3,000 characters in the table in INSERT. Then put 3000 characters in each field of Update Context2 Context3. There was a mistake at this time. .
Only a few tables.
This import is true. That table will have 812 column
