We are starting to test the bulk insert section of this import process and hit an unexpected issue.  We are importing the text file into a temp table to then...

Thank you for your prompt reply, please could you expand upon

"YIKES, including the in-line SQL "

as for breaking the original file down before...

Right, our developer has picked up the baton on this one and using bits of your suggestions and some of his own research and bits that I had found has...

Thanks for your replies - we have been looking into these methods and wheras they may work they do seem to be a very long way round.

Is there a way that...

Thank you everyone for your posts, it would seem though that i may have left off an important detail that may have an impact upon your suggestions;

this would be more...