I have a very simple DTS process that copies five columns from an Excel
spreadsheet into a SQL table. One of the fields is product description that
tends to be about 350-500 characters long. When I run the DTS, SQL Server
truncates the description field at 255 characters? Does anyone know what I
need to do to resolve this problem.

Are you seeing this issue?

www.sqldts.com/default.aspx?297


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Justin Patch" <JustinPatch (AT) discussions (DOT) microsoft.com> wrote

That's exactly what was happening. Thank you very much.

"Allan Mitchell" wrote:

That worked great for the import problem, but I also have to eventually
export that data back out to an Excel spreadsheet. The export works great to
a text file, but not for the xls file. I looked under the OLE DB properties
for the xls sheet but didn't see anything about Max characters per delimited
column. Is it possible to export the data back to an Excel sheet, or am I
stuck with a text file? Thanks for your help.

"Allan Mitchell" wrote:

Are you saying that the Export to Excel is cutting you short also?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Justin Patch" <JustinPatch (AT) discussions (DOT) microsoft.com> wrote

Yes, I can export fine to a text file but it will chop the field off at 255
on the export. If I have to I can use a text file, but I would really like
to use an XLS so that I can easily format the results.

"Allan Mitchell" wrote: