Trying to use SSIS SQL 2005 to import an Excel 2007 file (.xlsx).
I'm using Office 12.0 Access Database Engine OLEDB Provider with extended properties Excel 12.0;HDR=Yes;IMEX=1
The problem is when I have text with more than 255 characters. It basically defaults the source output to Unicode string[DT_WSTR] 255, If I change it it errors out.
I have done the registry change according to
but I think it only applies to Excel source not OleDb Source. (A Excel source does give me a text instead of string )
I have also tried to increasing the length of output such as 4000 instead of 255 but it doesn't allow either.
Anybody can help?I'm stuck for a day. Thank you very much for your help.
View Complete Post