Hi all:

I am trying to import a csv file into a SQL Server table. (It's a bit more
involved than that, with an ActiveX script doing the transformation).

The first 265 rows are done just fine, but then the process stops with the
error

Data for source column 1 ('Col001') is too large for the specified buffer
size.

The target is an nvarchar field with 255 chars. So, everywhere I use Col001
and Col003, I have

Left(DTSSource("Col001"), 255) ' with Col001 changed in Col003 where
appropriate

Row 266 in the source file is a row with more than 255 characters. At this
time, I don't really care about those characters. I don't understand why
this error occurs or how to get rid of it.

--

Sven

I've now changed the field in my SQL table to ntext, but the results are the
same.

--

Sven


"SA" <informatica (AT) freemail (DOT) nl> wrote

It is not about your destination it is about the driver.

http://support.microsoft.com/default...b;EN-US;281517


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Allan:

Thanks for your reply. I found that KB article before, but thought it didn't
apply, since I am importing a text file?

Oddly enough, it doesn't happen when I execute the package, only when I test
the transformation.

--

Sven


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote