Monday , December 11 2017
Home / Books / 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

SSIS Upgrade

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 SSIS 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.

This Ebook has Covered below Topics

  • TIP #1: Edit Package Configuration and Data Source after upgrading
  • TIP #2: Convert to project deployment model using Project Conversion Wizard .
  • TIP #3: Update Execute Package Task to use project reference and use parameter to pass data from parent package to child package
  • TIP #4: Parameterize PackageName property of Execute Package Task to dynamically configure which child package to run at execution time
  • TIP #5: Convert package configuration to parameter when possible

Download Book From Below Link:

5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012

Conclusion:

Did you find this post as useful? I hope you liked the article. Please share your valuable suggestions and feedback in the comments.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

Xamarin ebook

Free ebook: Creating Mobile Apps with Xamarin.Forms

Xamarin is a Microsoft-owned San Francisco, California-based software company founded in May 2011 by the engineers …

%d bloggers like this: