p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 (http://p2p.wrox.com/forumdisplay.php?f=333)
-   -   DTS Migration to SQL Server 20005 (http://p2p.wrox.com/showthread.php?t=78335)

madtech February 24th, 2010 12:17 PM

DTS Migration to SQL Server 20005
 
Hello,

I am new to SSIS 2005 and have recently migrated some DTS packages into SSIS. After migrating the packages I see that there are many duplicate Connection Managers created that are pointing to the same Server and Database.

I was wondering if there is any processing advantage to limiting the number of connection managers in the migrated SSIS packages.

As an example, my OLE DB Source and My OLE DB Destinations that are pointing to the same Server and Database will use one Connection Manager as opposed to the two that were migrated from DTS.

Any insight will be greatly appreciated.

Thank You
Michael-


All times are GMT -4. The time now is 12:28 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.