that still doesn't seem to be working. I added the namespace but nothing comes back 🙁

Hi,

Thanks for the response. Ok. To be honest I was thinking XML would be easiest. I'll have a little play and see what I can put together.

Hi ghollis,

It's our server so yes, CLR would be an option. That's a new area for me though in the realms of SQL Server but it does look interesting.

Are we...

Bit of an update if anyone ever stumbles accross a similar problem.

I've looked into Linked Servers and set one up. It basically points to a folder in my site where...

ok, that's a bit of a new thing for me but would it mean I could add my assembly to the DB and integrate it into my t-sql to work...

Yep, the format of the file is dictated to the client by me.

Basically, we are providing a bulk import of items into his database. At the moment, my script...

Thanks for the response guys.

I've set up a table to accept the CSV and the file is uploaded on the site (in an admin section) using a set structure so...

Hi,

Yes I'm using FOR XML and TYPE. I've actually solved this now. I wrote a function to replace some known problem characters and i just call that on each field...