[dba-SQLServer] DTS Connections and performance

Mark.Whittinghill at protective.com Mark.Whittinghill at protective.com
Wed Feb 1 10:06:24 CST 2006


In a DTS I have multiple simultaneous data pumps from the same connection. 
 Is there any performance difference in having them all reference the same 
connection, or in creating a new connection for each pump, with the same 
connection info.  As I set all connection info from an ini in a Dynamic 
Properties Task, managing a few connections is a lot easier than having 
50.

Thanks,

Mark Whittinghill
Sr. Programmer Analyst
Protective - Asset Protection Division
636.536.5720
Mark.Whittinghill at protective.com


-----------------------------------------
Confidentiality Notice: This e-mail communication and any
attachments may contain confidential and privileged information for
the use of the designated recipients named above. If you are not
the intended recipient, you are hereby notified that you have
received this communication in error and that any review,
disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and
deleting it from your computer. Thank you.



More information about the dba-SQLServer mailing list