Hi,

I'd like to import rows from an Excel File to an SQL Server 2005 table.
One column of my table is 500 varchar big and my Excel column contains
259 letters. The import task aborts because he has to truncate this
particular column. When loading all failed rows in another excel the
specific column is only 255 letters long.

How can I solve this problem?

Tanks Florian!

I used the SSIS Import Export wizard to design the data flow. After the
excel source it made a data conversion item where Input colomn and
output alias and the data type is listed (string [dt_str] length 500).

Should I configure something there?

I found an msdn article where the following registry has to be updated:


HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel

to solve my problem. Unfortunately it isn't installed under this path.
any ideas how to find it?

thanks

florian schrieb:

That's odd....you could try searching the registry for
values named TypeGuessRows
to try to locate the value in the registry.

-Sue

On 16 Aug 2006 06:28:09 -0700, "florian"
<florian.stammer (AT) gmail (DOT) com> wrote: