Will do Chris - sorry didn't realise there was such a great article as yours, I wondered how so many people got such neat data in the forum.

Will be back...

Wow thanks Mark, I had dabbled with the nodes method, the path I chose was wrong.

Works a treat many thanks again.

Paul

Thanks Jack, I thought as much. I have written a t-sql function which I will call outside of SSIS which will seperate the filed first before bringing into SSIS. I...

Wow thank you so much for the prompt and excellent reply. It works a treat. Now I can dismantle my horrible SSIS solution.

Thanks once again

Paul

Check your STOPLIST on the Resource database, I suspect WITH may be in there.

Oh thanks Wayne - that's perfect...

Thanks for your help it's very much appreciated and will be noted.

no offence taken in anyway shape or form.

To answer both questions I haven't included all of the sp as I did think it was only the final insert into which...

Here's what I've done so far (it's all a bid Noddy) right now.

The second table has just two columns. This all works fine until I have say 2 tickets remaining...