I re-visited this, and realised that SP2 wasn't installed on the client machine. So installing, and checking all the boxes has solved the issue.

I have no idea how the flat...

Still no luck. I wasn't able to re-register the dlls. Thanks anyway.

I'm going to keep trying - deskside support have suggested a rebuild - not exactly a preferred or proportionate...

Hi,

Thanks for your response. I should have made it clear that the option appears there in the toolbox (although not in the management studio import wizard) and it is checked...

Thanks for all the replies - you've all been a great help!

🙂

Thanks - that's great.

The pivot thing seems a bit inflexible. I'd seen some code which was dynaically setting the columns but couldn't figure out what it was doing before.

Any ideas...