Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drdexter33
Starting Member
12 Posts |
 Posted - 2011-06-23 : 17:04:33
|
| Hey There.We're running an SSIS package that's populating an Excel spreadsheet.It seems that we have a cast statement that is causing an error.Here's the cast:CAST(ProductDescription.Value AS varchar(255)) AS ItemDescriptionIf we change that cast [varchar(255)] to anything larger than 255, we get an error.Here's part of the error:Description: String or binary data would be truncated. End Error I thought that an excel field could take a larger field size than this.Anyone know for certain?ThanksDOug |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-23 : 17:27:18
|
| Could be wrong here, but doesn't Excel limit you to 255 characters per cell? Certainly older versions did.Or was/is it the Jet driver?Just tested that Excel 2007+ definitely allows more. |
 |
|
|
|
|
|
DTS Error to Excel