Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 attend our next webcast













































   Got a SQL tip?
            We want to know!

Connection Managers in SQL Server 2005 Integration Services SSIS

MSSQLTips author Edgewood Solutions By:   |   Read Comments   |   Related Tips: More > Integration Services Connection Managers

Problem
In SQL Server 2000 connections were made by dragging a connection type to the designer. The problem was that the number of connections was limited, and many of them had to be made using a scripting language like VBScript or JScript. The arrival of SQL Server 2005 included a brand-new SQL Server Integration Services that offers many ways to extract, tranform, and load data. Along with those new methods came a certain re-arrangement of objects as well as new ways to connect to the objects needed to move and manipulate data. Perhaps the most important is the new Connection Manager.

Solution
The Connection Manager is the gateway to all things data in SQL Server Integration Services. Whereas many connections had to be made manually using a scripting language in SQL Server 2000 Data Transformation Services, a variety of connection types are available in SSIS without scripting. When you open the Business Intelligence Development Studio (BIDS), create a new Integration Services project. When the SSIS Designer opens the Connection Manager is along the bottom of the designer. To create a new connection, right-click the area inside the Connection Managers section. A number of options are available inside the menu:

Connection Manager in SSIS Designer

Context manu when area is right-clicked

In addition to these connections, other connections can be created by clicking New Connection. When you select it a new screen appears with the additional connection types:

Additional connection types for SSIS

Next Steps



Last Update: 1/16/2007


About the author
MSSQLTips author Edgewood Solutions
Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com.

View all my tips


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates



       Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     





 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.