Thanks for the input. The scripts look interesting, as does the article in the T-SQL method.

Both methods appear to rely on the text being in the database first. ...

Is the help I am asking for inappropriate for this section? I wonder if it should have gone into the Newbie section?

Thanks for the swift reply.

Really? That sounds ideal.

My XML Files get read in a Foreach loop... so would the script task be able to use the same variable to...

Thanks Jack,

I will read up on OUTPUT CLAUSE to see how I can put it to use.

I appreciate your comments about potential duplicates. This is a situation that I...

I'll do that.

Thanks for your time.

Case and space sensitive. I'll remember that..thanks!

I think, once again, I haven't explained too well. I know which address belongs to which person because it comes through on...

Thanks Jack,

Using a staging table would be fine.

I think I understand the logic of performing the actions in the order that you state.

What I don't know how to...

Hi Adi,

I ran the attached file, and I can see that this achieves what I need.

Please forgive me though, and perhaps I am asking this question in the wrong place?...

Thanks Adi,

Yes I agree... but this has been ongoing for some time, and I am keen to prevent the overnight failures as soon as I can.

Could you please...

Sure Adi.. I understand that. The ampersand characters come from either Company Name or Address fields that are placed into the XML file by my supplier.

This is not something...

Hi All,

Still having terrible trouble with this.

Can anyone give me a pointer please?

:w00t:

--Thanks for the reply.

--Child tables. I will remember that.

--This is a data feed that will need to be run regularly, and not a one-off.

--I think I understand what you...

Thank you. I'll read the articles.

Brilliant. Works a treat thanks.

I will rememebr to use CASE rather than IF where possible. I must admit that I have not used CASE very much.

Thanks again!:-)

Nice work Nabha,

That was my first attempt at helping someone...

Your attempt was somewhat more sophisticated though.

It would be nice to know whether it has solved the problem or not..

🙂

<Edited: Excessive...