Thanks to all who replied, particularly Phil, who's method has worked for me.

I added the code to a Script Component, and created it as a Transformation, using an OLEDB Data...

Thanks Lowell

I am hoping to call via SSIS, but I could use the Execute SQL task within SSIS to run T-SQL. However I don't know anything about CLR... but...

Thanks Phil!

I'll give it a go. 🙂

Thanks for the advice John. I thought it might simply be something that could be handled via T-SQL or some type of script task.

Obviously I can use Execute...

In summary... I am not overly concerned about handling errors... I could look into error handling down the line... but initially I just want to call the URLs.

Hi John,

No I don't. This is a remote system. In truth this is a failsafe operation. We already have overnight full synchronisation with the remote system, but...

I may not have been very clear on exactly what I need help with! My apologies.

I already have my data import process. This is a data warehousing solution...

Brilliant! This works perfectly and is exactly the effect I was looking for.

Thanks very much for your help. That's very much thinking outside the box!

Thanks Henrico.

However I think that option is a little more drastic than I had in mind. I was hoping that I would still be able to report failure if...

Oh that's brillant! And it works perfectly.

Thanks very much for your help on this.

🙂

I have made some attempts. The following does <more or less> what I need:

ALTER TRIGGER [dbo].[trClearBounced]

ON [dbo].[Contact]

AFTER UPDATE

AS

IF ( UPDATE (Email) )

BEGIN

Update contact

SET bounced = 0

FROM contact...

Great. Thanks for the pointer. I'll try to get the trigger working now.

Wish me luck!

Oh well... I too have learned to live with it, and will continue to do so.

Like I said.... it is no more than a slight annoyance.

Thanks for the reply!

Paul

I'll check it out.

Thanks again.

🙂

Thanks very much for your assistance, Chris. That works great.

I prefer to use query 2, as I can understand it. I am not too sure on how partitioning...