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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-15 : 08:28:40
|
| Mike Lascut writes "Basically I'm trying to import large amounts of HTML code into an nTExt field.The text (around 15,000 characters) is properly stored in in MS Access Memo fields.When I run the DTS it truncates the field, probably to 255 characters.The error message I get is "Data for source column 7 (col) is too large for the specified buffer size".I found up the same message in MS KB that applies to excel OLE DB provider and they provide a fix via registry modification.Any idea?Really appreciate your timeMike Lascut" |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2004-06-17 : 02:27:16
|
| i have a excel file which has a description which is move than 255 and when i use DTS to import and get the same problem tried to change the registry but still it does not work. i change the default to 0 to 8,12,22 no chnage same problem. need some solution....======================================Ask to your self before u ask someone |
 |
|
|
|
|
|
DTS from MS Access to SQL Server fails at a Memo to nText field