February 7, 2012 at 12:09 am
Hi,
I am new to ssis,
I am importing excel sheet , in which last column "comments" has large size data i.e data of 15 or more trailing mails data. I created table with column 'comment ' having datatype as ntext .And Not every row contains that much data. when i loaded it first and i found it loads only 255 charatcter of data and rest get truncated.so i searched and found ssis takes some sample rows from excel and fixes datatype and size.Hence i increased that sample rate in registry which found maximum 16 rows can be sampled. but in my case this large sized rows can appear at any sequence may be at 55th row,60th row or100th row or at any number , more than one time.
February 7, 2012 at 12:19 am
So you adjusted TypeGuessRows in the registry to 0?
In the Advanced Editor for the Excel source, check the datatype for the output column "comment".
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply