>> "We don't need no stinkin adjusting journal entries. We can just change the database." <<

Imagine the auditors turning up and asking how a certain figure was arrived at......

I wish someone would double some of the information in our payroll...

Would this table not benefit from a primary key? As already said, it should have one anyway, and if you're trying to avoid duplicates then that speaks for itself....

Trouble is, you'd still need varying filenames, so it's either still a Dynamic Properties Task or a separate package for each country, as far as I can see...

How bizarre. I too tried Googling on it (specifically on "Server: Msg 3721" including the quotes) and got one result. Seems like this guy had the same...

Could you not do this within a DTS package using a Dynamic Properties Task and a bit of ActiveX?

Loop through the table, call a transformation for each country found (after...

Why use dynamic SQL; any specific reason? Why not just this:

CREATE procedure sp_runpkg @t varchar(100)

as

declare @s-2 nvarchar(200)

set @s-2 = 'dtsrun /S /E /N' + ...

Sounds more to me like the rows deleted in the past have not been duplicates, and this one is, rather than being that anything has changed.

This is an Enterprise Manager...

By what method are you trying to perform the deletion? From within Enterprise Manager...?

If you're trying to delete a duplicate row from within EM then you will always get...

Please excuse my terminology... but happy it seemed to make sense

Oh... hang on... NULL > 0 evaluates to false so no, NULLs would be excluded by that Where clause.

It should do, by returning NULL. Are you using Remi's re-vamp of my code to do a Select from a table? If so, could the missing rows be...

Just now... it fails. I posted at the same time as you and hadn't considered there being no space.

Remi's is better for error trapping... so if you can possibly get postcodes with the space missing, use his.

DECLARE @PostCode varchar(8)

SELECT @PostCode = 'NE1 1AA'

SELECT LEFT(@PostCode, CHARINDEX(' ', @PostCode) - 1)