Post reply

RetainSameConnection performance ?

  • February 28, 2014 at 7:32 pm

    #288843

    I am inserting millions of rows into a table with a package called ETL1. Takes about 30-50 minutes usually. There are other ETL jobs that also READ this table or insert rows into it. ETL1 uses RetainSameConnection = TRUE to connect to table. I have NO transactions in my package.

    Will this cause any problems ? Should I set it to false ?

  • March 4, 2014 at 2:46 am

    #1693790

    I don’t think so because RetainSameConnection = TRUE to control flow of an SSIS package threads together various control tasks. It sets a transaction that can span into multiple tasks using the same connection.

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

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