I'm having a problem,
I have to bring Excel data to SSIS 2005, but has text fields in the spreadsheet that reach 22475 characters but when put in SSIS the field is as follows:
DataType: Unicode string [DT_WSTR]
Length: 255
I've tried to force conversion in the Advanced Editor for text stream...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.