Post reply

Table Transform

  • February 9, 2018 at 1:12 am

    #343903

    I need to do a transform having SQL Server table source loaded into a SQL Server table destination. What are the configuration settings to be done for making it highly performance oriented?
    I am newbie to SSIS. Still learning.

  • February 9, 2018 at 12:01 pm

    #1979292

    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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply