Hi All

Many thanks to those who have responded to this thread so far, I apologise for the delay in my response - holidays and project pressures elsewhere have made it...

I've done some further digging, and it'll only complain when you make use of controls that are outside of copying data. So moving data with a source and destination if...

Normally I would agree with you, but I have 2 packages. One of them works, the other does not whereas they're both package deployment model, executed with dtexecui with File...

They're both package deployment model.

I don't believe SSIS is installed, but then wouldn't I get the same error against both packages?

Your view is too large, and some of the rows within the view exceed the maximum allowed bytes per row.
Break your view down into smaller views or look into...

The objects complaining about the duplication were pre existing tables, but at the subscriber they have creation dates on them of yesterday not long after the snapshot was taken.

Hello

Both allow_anonymouse and immediate_sync are set to 0 on that publication. All published objects are recreated at the subscriber during a reinitialise, I believe.

Interestingly, the rows...

Crisis over, bizarrely restarting my SSMS has released the lock. Bizarre, since it was doing next to nothing!

You live and learn!

This thread may help.

http://www.sqlservercentral.com/Forums/Topic882222-146-1.aspx