This error means that the user you have connected the migration with does not have permissions to create campaigns. Please update the permissions for the user in Salesforce by enabling the Salesforce "Marketing User" on the user's record.
Entity type cannot be inserted: Campaign
Written by Ashley Milne