SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials

Leave a comment (1) Go to comments

Microsoft made a number of improvements on this new release "Denali" specially for Integration Services. These are some of the key improvements in SSIS

Migration and Deployment

  • Working with Integration Services projects in Business Intelligence Development Studio (BIDS)
  • Using the Deployment Wizard to deploy an Integration Services project
  • Import an Integration Services Project from the Project Deployment File
  • Import an Integration Services Project from an Integration Services Catalog
  • Migrate an Integration Services 2008 Project to the Project Deployment Model
  • Configure an Integration Services project using SQL Server Management Studio (SSMS)
  • Running a package using SQL Server Management Studio (SSMS)

Impact Analysis and Data Lineage

  • Extract Dependency Information Using the Dependency Extractor Command Prompt Tool
  • Extract and View Dependency Information
  • Extract and View Dependency Information for SQL Server Objects Using the MSSQL Provider

SSIS Designer Enhancements

  • Working with the Data Flow Task’s Source Assistant and Destination Assistant
  • Resolve Column References in a Data Flow Component
Migration and Deployment
  • Working with Integration Services projects in Business Intelligence Development Studio (BIDS)

 


  • Using the Deployment Wizard to deploy an Integration Services project

 

  • Import an Integration Services Project from the Project Deployment File

 

  • Import an Integration Services Project from an Integration Services Catalog

 

  • Migrate an Integration Services 2008 Project to the Project Deployment Model

 

  • Configure an Integration Services project using SQL Server Management Studio (SSMS)

 

  • Running a package using SQL Server Management Studio (SSMS)


Impact Analysis and Data Lineage
  • Extract Dependency Information Using the Dependency Extractor Command Prompt Tool

 

  • Extract and View Dependency Information

 

  • Extract and View Dependency Information for SQL Server Objects Using the MSSQL Provider


SSIS Designer Enhancements
  • Working with the Data Flow Task’s Source Assistant and Destination Assistant

 

  • Resolve Column References in a Data Flow Component

 

Note : All these Video are taken from Microsoft SQL Server "Denali" Resource Center.

EOF - SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: