Add New Skills!

Udemy
Showing posts with label Integration Services. Show all posts
Showing posts with label Integration Services. Show all posts

Sunday, June 5, 2011

Integration Services new features in Denali

Great Introductory session by Peter Saddow on Integration Services in SQL Server code-names “Denali”. I have tried to highlight the key learning from this session. Download slides here

SSIS contains new UI improvements for increased developer productivity. It contains new features aimed towards improved deployment, configuration and management of SSIS projects. Everything you had in SSIS 2008 will continue to work; upgrade process should be relatively seamless – Denali comes with a Migration Wizard. DTS 2000 and ActiveX scripts now retired in Denali.

Build SSIS Packages now in Visual Studio 2010

image

Note:

  1. rounded corners
  2. improved annotations
  3. undo-redo supported
  4. new getting started window

New toolbox and variable buttons for better performance (for enhanced developer experience):

image

Apply Expressions in Connection Manager and Variables:

imageimage

Work Offline option for Connection Manager:

image

Easy to change Variable Scope. By default, a variable scope is set to the package.

image

Copy & Paste now more intelligent: if you copy and paste an object, it now copies over its dependents.

Upgraded VSTA 3.0 engine under Visual Studio 2010 shell: VSTA 3.0 support .NET 4.0 (C# and VB.NET)

image

Data Flow Improvements: Flexible Order of Authoring makes it possible to develop a package backwards from the destination.

image

New Facebook connectors:

image

New Column Mapper: Automaps by name, ability to filter, export & import mappings to/from excel

image

Add new data source automatically picks only installed data providers:

image

New Data Quality Service Cleansing Transform:

image

image

Parameters are replacement for configuration: these are read-only variables.

image

Parameters can be defined as Sensitive and/or Required.

image

Projects: Combines all packages into a single deployable ISPAC file.

image

Legacy file based deployment models can be converted to Project based deployment model with the help of a built-in wizard.

image

New Environment configuration lets you run the package under a specific environment under SSMS.

image

New Dashboard to show complete status of the package in one place when the package is run on the Server. By default all events are logged on the server.

image

You can choose to run the package under 64-bit or 32-bit.

image

Data Tap: You can output the data flowing at any path in a text file (csv format) for later investigation using plain SQL.

image