Ok, just to add to this topic since this was really good information, but still didn't completely solve my problem.

Make sure the sid for the owner in your DB matches...

Just in case others have gotten here for the same reason. Make sure that the account your proxy/credential is using is a user in its default database in SQL...

Thanks for the additional information and will probably help someone in the future who's googling this error.

In my case, the table was not wide and in general would have less...

Just in case anyone else has gotten here for the same reason I did which was you're trying to build an SSIS package based on a stored procedure that is...

If you got here as I did because of this error:

sp_MSdistpublisher_cleanup can only be executed in the database.

Changed database context to 'master'. (Microsoft SQL Server, Error: 21482)

And the issue...

I had this problem doing an update to the clustered index which was *not* a unique index. If I updated the column to Null (it had a default of...