Wednesday, November 9, 2011

SQL Server Denali: SSIS New Features/Enhancement - Video Tutorials

Microsoft improved number of existing features as well as added New features for SQL Server Integration Services (SSIS) along with the release of "Denali".

Some of the Enhancements of SSIS are listed here
Migration and Deployment (Clink on the following list to view the Video..)
  1. Working with SSIS projects in Business Intelligence Development Studio (BIDS)
  2. Using the Deployment Wizard to deploy an SSIS project
  3. Import an SSIS Project from the Project Deployment File
  4. Import an SSIS Project from an Integration Services Catalog
  5. Migrate an SSIS 2008 Project to the Project Deployment Model
  6. Configure an Integration Services project using SQL Server Management Studio (SSMS)
  7. Running a package using SQL Server Management Studio (SSMS)
SSIS Designer Enhancements 
  1. Working with the Data Flow Task’s Source Assistant and Destination Assistant
  2. Resolve Column References in a Data Flow Component 
Note: All these Video are taken from Microsoft SQL Server "Denali" Resource Center.

No comments:

Post a Comment