Wrox Programmer Forums
BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5
This is the forum to discuss the Wrox book Expert SQL Server 2005 Integration Services by Brian Knight, Erik Veerman; ISBN: 9780470134115
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 24th, 2010, 12:17 PM
Registered User
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to madtech Send a message via MSN to madtech
Default DTS Migration to SQL Server 20005


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

Similar Threads
Thread Thread Starter Forum Replies Last Post
DTS migration from 7.0 to 2005 vishwjeet SQL Server DTS 7 July 4th, 2008 09:53 AM
Tables migration from Access to SQL Server-VB.NET ayazhoda VB.NET 2002/2003 Basics 2 May 3rd, 2007 05:59 AM
Data Migration from Oracle to SQL Server AB SQL Server DTS 1 July 27th, 2005 12:38 AM
Migration hyper File to SQL Server chanour2003 SQL Server 2000 0 June 19th, 2004 06:24 AM
SQL Server Database migration shahchi1 SQL Server 2000 2 January 23rd, 2004 02:38 PM

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