Programming4us
         
 
 
SQL Server

SQL Server Integration Services : Connection Projects in Visual Studio

11/30/2010 3:08:15 PM
Microsoft is trying to make it easier to get data sources or data targets defined and ready to utilize with SSIS packages. From Visual Studio, you can now create an Integration Services Connection project. A wizard takes you through defining the data sources and connections for an SSIS package. As you can see in Figure 1, this wizard allows you to jumpstart the data source/connection managers you might need for a new SSIS package.
Figure 1. The Visual Studio Integration Services Connection Project Wizard.


You can then step through the buildup and testing of the connection one connection manager at a time. Figure 2 shows the various data providers available through this wizard and the creation and testing of one to SQL Server.

Figure 2. Select Data Providers Integration Services Connection project wizard.


After you finish using this wizard, you are set to start defining your SSIS package with the data sources and connection managers ready for use in your data flows, as you can see in Figure 3.

Figure 3. The Visual Studio Designer with connections ready for use.



Other -----------------
- SQL Server Integration Services : The Package Execution Utility (part 3) - The dtutil Utility
- SQL Server Integration Services : The Package Execution Utility (part 2) - Running Packages
- SQL Server Integration Services : The Package Execution Utility (part 1)
- SQL Server Integration Services : The SSIS Designer
- SQL Server Integration Services : Running the SSIS Wizard
- SQL Server Integration Services : A Data Transformation Requirement
- SQL Server 2008 : SSIS Tools and Utilities
- SQL Server 2008 : SSIS Architecture and Concepts
- SQL Server 2008 : SQL Server Integration Services - SSIS Basics
- Defensive Error Handling : Using Transactions and XACT_ABORT to Handle Errors
- Managing Security Within the Database Engine : Securables
- Managing Security Within the Database Engine : Database Security
- Managing Security Within the Database Engine : Creating SQL Server Principals
- SQL Server 2008 : Performance Tuning - Locks, Blocking, and Deadlocks
- SQL Server 2008 : Performance Tuning - Tracing
- SQL Server 2008 : Implementing Error Handling - Managing and Raising User-Defined Errors
- SQL Server 2008 : Implementing Error Handling - Understanding Errors
- Implementing SQL Server Objects Using Managed Code (part 2)
- Implementing SQL Server Objects Using Managed Code (part 1)
- Encryption Catalog Views
 
 
Most View
- Recovering from a Disaster in an Exchange Server 2010 Environment : Recovering from a Site Failure
- .NET Components : Serialization and Class Hierarchies (part 1) - Custom Serialization and Base Classes
- Exchange Server 2010 : Managing Public Folders
- iPad SDK : Preparing Dudel for a New Tool (part 2) - Implementing Changes to the Controller Class
- Microsoft Dynamics AX 2009 : Working with Forms - Building dynamic form
- Windows Phone 7 : Getting Around the Games Hub
- Configuring a Microsoft Exchange Server 2003 Infrastructure : Front-End and Back-End Servers
- Recovering from a Disaster in an Exchange Server 2010 Environment - Recovering from a Boot Failure
- SQL Server 2008: Administering Database Objects - Working with Tables (part 1) - Default Constraints
- Exchange Server 2010 : Availability Planning for Mailbox Servers (part 6) - Controlling Database Activation
Top 10
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 3) - Configuring Recipient Filtering
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 2)
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 1)
- Implementing Edge Services for an Exchange Server 2007 Environment : Installing and Configuring the Edge Transport Server Components
- What's New in SharePoint 2013 (part 7) - BCS
- What's New in SharePoint 2013 (part 6) - SEARCH
- What's New in SharePoint 2013 (part 6) - WEB CONTENT MANAGEMENT
- What's New in SharePoint 2013 (part 5) - ENTERPRISE CONTENT MANAGEMENT
- What's New in SharePoint 2013 (part 4) - WORKFLOWS
- What's New in SharePoint 2013 (part 3) - REMOTE EVENTS