Workflow Properties
You can control the behavior of each part of a package's workflow by adjusting its workflow properties. I won't go through all of these, but some of them are very handy to know about, especially when building more complex packages. You bring up the Workflow Properties dialog by right-clicking a package step and selecting Workflow Properties from the popup menu.
Close connection on completion Property
The Close connection on completion option instructs DTS to close the connection associated with a task after it has completed. This is useful in the following circumstances.
There are a limited number of connections available on a data source and you need to be conservative with them.
The cost of maintaining an open connection ...
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
