• It really depends on what type of transformation you are planning to do. The most common properties that can help with performance are the "Rows per Batch" and "Max Insert Commit Size" properties in your data flow. But there are also other factors that play a part, so it really depends on what you're trying to do.

    Here's an article with a few good practices you should follow: https://www.mssqltips.com/sqlservertip/1840/sql-server-integration-services-ssis-best-practices/