Export to Excel - data length exceeds 255 characters

 

If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it

http://support.microsoft.com/default.aspx?scid=kb;en-us;281517

Published 22 June 2009 14:08 by Madhivanan
Filed under: , ,

Comments

No Comments