Hello!
I looked through the archives but couldn't find anything
there.
I make a connection to an excel file and move a single
worksheet through a data pipe to a table on sql 2000. The
execution of the DTS package fails if there are cells
with more than 256 characters in the spreadsheet.

I worked arround it by copy pasting the cells into
notepad and saving that to a text file. Using the
file instead of excel as the source in DTS makes
things work.

Is there a better way to get this done?
Thanks, Tobias.

What SP of SQL Server?
What is the error?

It almost sounds like this

DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)




"Tobias Oed" <tobiasoed (AT) hotmail (DOT) com> wrote