5TSSSISU_SQL_Server_2012.pdf

5 Tips for a Smooth SSIS Upgrade to

SQL Server 2012

Runying Mao, Carla Sabotta

Summary: Microsoft SQL Server 2012 Integration Services (SSIS) provides significant

improvements in both the developer and administration experience. This article provides

tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration

Services successful. The tips address editing package configurations and specifically

connection strings, converting configurations to parameters, converting packages to the

project deployment model, updating Execute Package tasks to use project references

and parameterizing the PackageName property.

Category: Quick Guide

Applies to: SQL Server 2012

Source: White paper ( link to source content )

E-book publication date: November 2012

without the written permission of the publisher.

Microsoft and the trademarks listed at

http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the

Microsoft group of companies. All other marks are property of their respective owners.

The example companies, organizations, products, domain names, email addresses, logos, people, places, and events

depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,

logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided without any

express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors

will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Contents

Introduction ............................................................................................................................................ 4

TIP #1: Edit Package Configuration and Data Source after upgrading ....................................................... 4

TIP #2: Convert to project deployment model using Project Conversion Wizard ...................................... 6

TIP #3: Update Execute Package Task to use project reference and use parameter to pass data from

parent package to child package.............................................................................................................. 7

TIP #4: Parameterize PackageName property of Execute Package Task to dynamically configure which

child package to run at execution time .................................................................................................... 9

TIP #5: Convert package configuration to parameter when possible ...................................................... 10

Conclusion............................................................................................................................................. 11

Introduction

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the

developer and administration experience. New SSIS features have been introduced in order to improve

developer productivity, and simplify the deployment, configuration, management and troubleshooting

of SSIS packages .

SQL Server 2012 Integration Services introducesthe project as a self-contained, deployment unit.

Common values can be shared among packages in the same project through project parameters and

project connection managers. ETL developers caneasily reference child packages that are inside the

project.

Solutions that were created in earlier versions of SSIS (pre-SQL Server 2012) will be supported in SQL

Server 2012. When you upgrade the solutions, you can take advantage of the new SQL Server 2012

features. Although in SQL Server 2012 SSIS offers wizards for upgrading most solution components,

there will be a few settings that you’ll need to change manually.

Here are a few tips that can help to make the upgrade successful.

TIP #1: Edit Package Configuration and Data Source after upgrading

The first step to upgrade an SSIS solution is to run the SSIS Package Upgrade Wizard. The SSIS Package

Upgrade Wizard makes appropriate changes to package properties and upgrades the package format.

The wizard launches when you open a pre-SQL Server 2012 package in the SQL Server Data Tools for the

first time. SQL Server Data Tools replaces (BIDs). The wizard can also be launched manually by

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: