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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 export to excel-column problem?

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2012-08-28 : 11:31:32
Hi

I am using export wizard of Tasks to export my query to excel sheet...
But The problem is that I ahve a coloumn customer_comments which is throwing up eror since it got more data than 255 char...

When i cast it to to varchar(255) the export is successful but my data is truncating ...how can i do it without truncating the data..

Thank you
   

- Advertisement -