March 4, 2015 at 1:10 am
Hi,
When mapping the xls with data source (keeping in mind that the xls picks top 8 rows to decide the data type to be assigned to a column), we ensured that all our data was 3000 chars long for about 200 odd rows (not just the first 8). This resulted in xls recognizing it as a Unicode_text. We converted the output column (under advanced editor) to DTS_STR with a length of 500.
We though we were all set.
However, when a file is to be read in real time, it truncates/errors if the length of any row beyond the 8th row is greater than 257 (don't know why this odd number)
Can some one help me understand why this is happening and what can be done to avoid truncation of rows beyond the 8th row?
NOTE : registry key edit is not possible
Any help will be greatly appreciated!!!
Thanks,
Namrata
March 9, 2015 at 10:11 am
Hi
Which version of SSIS are you using?
In Data Flow --> try adding a 'Data Conversion' component and map to your required destination. Also, for Data Conversion component, 'Configure Error Output' to 'Redirect row' and write to a text file or to a database table, so you can see which records are causing truncation error.
Ronnie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply