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.
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 ...