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
- SharePoint 2010 : Upload a Picture to a Picture Library
- DirectX 10 Game Programming : Adding the DirectX Libraries
- Windows7: Managing Network Connections (part 1)
- Exchange Server 2007: Configure a Unified Messaging Server - Create a UM IP Gateway
- CSS for Mobile Browsers : Where to Insert the CSS (part 2) - Media queries
- Windows Phone 7 : Connecting a Bluetooth Headset
- Windows Small Business Server 2011 : Deploying a Second Server (part 2) - Performing Post-Installation Tasks - Adjusting Time Zone Settings, Configuring Network Settings
- SharePoint 2010 : Create a New Document Library
- Starting a New BizTalk 2009 Project : BizTalk Assembly Naming and Versioning
- iPhone Programming : Other View Controllers - Tab Bar Applications
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