Ssis where is retainsameconnection

Regarding the value in a configuration: you can easily check this by creating a configuration through the package configurations editor. Set the property to true, create the configuration and check what SSIS generated. Need an answer? Great explanation! So its like the singleton pattern in object oriented programming? You must be logged in to reply to this topic. Login to reply. You are commenting using your Twitter account. You are commenting using your Facebook account.

Notify me of new comments via email. Notify me of new posts via email. Menu Skip to content Home About. Search for:. As always thanks for looking! Share this: Twitter Facebook. Like this: Like Loading Retain Same Connection. Hey Daniel, From my recollection you are correct. Thanks for checking out my blog! In addition to the temporary table reuse, a TRUE value for this property can also be useful in managing transactions and reducing the number of recurring connection requests to a server.

Really heplfull information. By setting retainsameconnection to TRUE, in the first task I set the session info and then in the next dataflow I extract the data. Your email address will not be published.

Search Search for:.