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
- Cloud Security and Privacy : What Are the Key Privacy Concerns in the Cloud?
- Securing Exchange Server : Configure Message Hygiene Options (part 2) - Protect Against Unwanted Mail Sources
- Microsoft Visual Studio 2010 : Reports and Debugging - Using the Parallel Stacks Window
- Exchange Server 2010 : Manage Access for Mobile Devices (part 1) - Configure Mobile Device Connectivity
- Programming with SQL Azure : Connecting to SQL Azure (part 3) - ODBC
- iPad SDK : Implementing an About Panel in a Modal Way (part 2)
- Windows Server 2008 : Configuring IIS Security (part 8) - Adding Handler Mappings
- Backing Up with the dump Utility (part 1) - Syntax of the dump Command & The Options to the dump Command
- Windows Server 2008: Performance and Reliability Monitoring (part 1)
- Windows Phone7: Pinning a Contact to Start
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