Hello There,

I am getting the an 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\Engi nes\Excel

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

Any help is greatly appreciated. Thanks in advance

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

You have obviously looked at this article which is where I was going to
start you off.

http://support.microsoft.com/default...b;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


"SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote