Whenever
a task uses a connection manager to connect to source or destination
database, a connection is opened and closed with the execution of that
task. Sometimes you might need to open a connection, execute multiple
tasks and close it at the end of the execution. This is where
RetainSameConnection property of the connection manager might help you.
When you set this property to TRUE, the connection will be opened on first
time it is used and remain open until execution of the package completes.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment