I have automated my restore of databases from production to dev environment. But when testing some of my SSIS packages one of SSIS packages runs just fine on staging database but no rows are created.
If I drop and re-create target table then all is well. Is this some sort of table/schema level permissions. I have been staring at this like for a couple of hours. I am at a roadblock