sql server dts: I am getting this error trying to import data from a text file to database

Data for source column 3 ('hdrall_') is too large for the specified buffer
size.


Does anybody know ho to increase the buffer size

Thank you

Have a read of this

http://support.microsoft.com/default.aspx?scid=kb;en-us;281517

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Hello There,

I am getting the same error trying migrate data from Excel to Oracle 9i using DTS:

Error Msg: "Data for source column 50 ('GENERAL_CO') is too large for the specified buffer size"

Its breaking at the first row in the column 'GENERAL_CO' where the data is more than 255 characters in length.

I tried modifying the registry : "TypeGuessRows" in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel

from the default value('8') to '0' but still I am getting the same Error !!.

Any help is greatly appreciated. Thanks in advance

---
Posted using Wimdows.net NntpNews Component -