I am using DTS (the version that shipped with MSSQL 7.0).
I am trying to import at space-delimited text file into a database table.
I have one column in my text file which tends to exced 255 characters.
When this occurs, I run into the following error during the import:
'data for source column 3(colname3) is too large for the specified buffer size.'
Microsoft recommended changing the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\TypeGuessRows from 8 to 0.
This did not work.
Any suggestions for defeating this error would be greatly appreciated.