Thanks all for your help on this one.

My research indicates numerous possible causes, but in this instance, it looks to be a permissions issue going across domains.

J

Thanks both for your speedy answers!

Firstly the permissions... surely "Everyone" would encompass the SQL Server account?

And yes - I'd love to have the file locally - but it's impossible in...

You could also add it as a Linked Server.

Try this:

[font="Courier New"]declare @strSQL varchar(1000)

set @strSQL = 'INSERT INTO dbo.Person ('

select @strSQL +=ColumnName + ',' from #Test

set @strSQL = left(@strSQL,len(@strsql)-1)

select @strSQL += ') VALUES ('

select @strSQL += case...

OK, sounds like you have inherited some dodgy data, but what can you do.

My understanding of your problem is that you want to "cluster" CompanyNames where the first word is...

Break the string and insert the value of @oldUser.

Aha!

I'll get that installed. Thanks for your help.

That's great - many thanks for your help.

Thanks very much for that guys.

Maybe Im being blind but I cant find "DestinationObjectProperties" in the "Edit All Package Properties" screen... am I looking in the wrong place?

Thanks...