March 11, 2011 at 5:51 am
Hi,
I need to export data from SQL server to Excel and I have created a SSIS package for the same but as Excel by default takes text length as 255 I am getting error when I am trying to export TEXT data type or VARCHAR data having length more than 255 char. I have added the Data Conversion task also but issue still exists.
Kindly suggest.
Regards,
AJ07
March 11, 2011 at 7:54 am
Read the section about Truncated Text in the following article:
http://msdn.microsoft.com/en-us/library/ms141683.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 14, 2011 at 3:35 am
Thanks koen,
But here I am using Excel 2007 my export working fine for Excel 97-2003 but as this has boundation of limited rows i can not use it. i tried to use the Excel 2007 and except Text and Varchar>255 all my data types are exporting properly.
I tried to search for the same but couldnt get much about the issue.
Kindly suggest.
Regards,
AJ07
March 14, 2011 at 3:46 am
There is a similar registry setting for the ACE OLE DB provider used by Excel 2007.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply