It's a simple SSIS package with one, Transfer SQL Server Objects, for the tables in the database. We are copying all the tables in the given database.

I don't see anywhere where there are options/parameters we can use to control how the system handles this data.

I am wondering if anyone has had this issue and what they did to resolve it.