Transcript Introducing New Team-based Data Integration with SSIS

INTRODUCING NEW TEAM-BASED DATA
INTEGRATION WITH SSIS
Matthew Roche
Senior Program Manager
Microsoft Corporation
This document has been prepared for limited distribution within Microsoft. This document
contains materials and information that Microsoft considers confidential, proprietary, and
significant for the protection of its business. The distribution of this document is limited to
those solely involved with the program described within.
Confidential and Proprietary © 2011 Microsoft
Last Updated: Friday, July 17, 2015
WHAT’S NEW IN SSIS FOR SQL SERVER
2012
A quick tour of the 2012 release
DEVELOPER EXPERIENCE ENHANCEMENTS
•
•
•
•
•
•
•
•
•
•
•
•
•
Visual Studio 2010 & .NET 4.0 support
Undo / Redo
New WPF design surface
New package XML format
Expression markers on icons
Variable tool improvements
Package and project parameters
New data flow column mapper
New CDC components
Data Quality Services integration
New expressions & removal of 4000 character limit
Auto-save project recovery
New SSIS Toolbox
ADMIN EXPERIENCE ENHANCEMENTS
•
•
•
•
•
•
•
•
•
•
•
•
SSIS Server
Simplified deployment & configuration
Automatic logging
Management dashboard
Built-in reports
Improved SSMS management experience
T-SQL management API
Advanced troubleshooting features
Package performance analysis
CDC for Oracle service
PowerShell support
Environments, parameters and version management
A DAY IN THE LIFE…
…of a SQL Server 2012 SSIS team
TEAM-BASED DATA INTEGRATION
We’re going to…
…by using
Build an ETL solution
Capture data changes
Version and control packages
Diff and merge packages
Deploy project
Manage projects and
packages
• Execute packages
• Troubleshoot data flows
• Monitor package execution
•
•
•
•
•
•
•
•
•
•
•
•
Visual Studio 2010 (SSDT)
New CDC components
Team Foundation Server
New package XML format
.ISPAC project files
SSMS and the SSIS server and
catalog
• T-SQL management API
• Data taps
• SSMS reports
DEMO
FURTHER. FORWARD. FASTER.
•Learn more
Visit the Microsoft Virtual Academy
Free technical SQL Server training courses
•Get more
Download SQL Server 2012 Trial Software
180-day evaluation of SQL Server 2012
•Do more
Participate in virtual launch activities and collect
points for prizes
The more points you earn, the bigger your prize could be
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market
conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.