What row number does it first fail ? The provider that dts is using is guessing as to the size of the column that it is trying to read - if this is not one of the 1st eight rows it hits, you will have problems. If this is your scenario, you will need to modify the typeguessrow key in your registry.
It's line 388 - which is the first of the longer entries in that column.
Thanks for your explanation - so it uses the first 8 rows to <guess?> how much memory to allocate to that column, and if the first entires are quite small it'll fall over when it gets to bigger ones further down?
Can I not simply move a row with lots of data in the offending column, to the top? Then it'll know to expect similar entries further down? Or am I missing something?
If so, could you possibly point me in the direction of any further info on modifying the typeguessrow key? I don't muck about with registries all that often and the thought of doing it on our live database server doesn't exactly inspire confidence...
Yes you can move it to the top, but that can be a pain if you process alot of these files. For the registry - run regedit and search for typeguessrows - there might be a couple, so make sure you are on the correct one - excel version x. Then just modify the typeguessrows to a number that fits your situation.
Ah, I just moved it to the top in the end. The order these things are in doesn't matter much, and I'm only going to be doing this once (hey, I leave at the end of the week ). But thanks for the registry info.