Ok, here is code for the source table, destination table and the select query that I am using to remove duplications from the source.

I now need to check the...

Thanks Matt, that did it!! appreciate the help.

That's working a treat on the production box. Thanks a lot.

I would really appreciate it if you could give me a brief explanation as to why you think my method...

Thanks for the reply, i tried that but it gave me an error pointing at the ) bracket. i then tried the following and this gives me all the results,...

Thanks for that. I changed all the package passords and configured them to blank in both SQL databases and that did the trick.

Thanks again.

Thank you for the reply. When i edit the package in notepad i find this line

DTS:Name="ProtectionLevel">1<DTS:Property Shall i chnage it to -1?

I also see

Should this also be...

Thanks for that the second option worked a treat.

Thanks Lutz, I will go through what you have said and reply back if i have anything else to pick your brain with. You have been very helpful thanks again.

Ok, my head hurts but i like it cause we are getting somewhere!

I am running my query that i first wrote about here that gives me the 77 rows, then...

Ok it's done. Here are the results.

USE [example_db]

--===== If the test table already exists, drop it

--IF OBJECT_ID('wce_ilr','U') IS NOT NULL ...

It's running but might take another 30 -40 minutes to get the result. As soon as it completes i will post the results. I would have thought that would have...

Well here it is these are 5 off the 77 rows that i am getting returned on the live system from the wce_ilr table and 5 rows selected by uniqueid...

I will do the same for wce_ilr with just the columns i am working with and 5 rows of data and the same with the wce_contact table but it might...

Hi,

Here is the sample you requested showing the two fields from both tables I am matching against. It doest matter which of these finds a match I just want results...

Thanks for the reply. The query just finished over 2 hours later and only had 700 rows.