Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 24th, 2010, 11:17 AM
Registered User
 
Join Date: Feb 2010
Location: West Caldwell, NJ
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

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-
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 01:38 PM



All times are GMT -4. The time now is 03:03 PM.


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