June 21, 2009 at 12:14 pm
In my SSIS package i have dataflow task inside a Foreachloop container to load a list of xml files in a folder to database table. After the first couple files were loaded, it stopped with error: "OutletID is too large to fit into output column". I checked the file and found no difference for this field between the loaded file and the not loaded file. I then manually loaded just that one file but still got the same error. I changed the column length to maximum in the table but still had the error.
Then i edited the xml source to set 'ignore failure' for this column then the file was loaded, but the value for this field is null, all other columns are good. but i need the value of that field.
I opened the xml file and also opened it in TextPad I do not see anything wrong with that error field, there is no empty space or anything in that field. is that possible that there is some big space or empty string in the field when the file was genertated but it just can't be seen by simply opening the file?
I searched the error but do not seem to find any helpful answer.
Thanks!
July 20, 2009 at 2:09 am
What data type is used for the OutletID column in the destination table? Does the value in the source file exceed the limitations of the destination colum type?
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply