Início > Version Upgrade > Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

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.

  • 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 Whitepaper Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Link:http://blog.sqlauthority.com/2011/12/03/sqlauthority-news-download-whitepaper-5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012/

Categorias:Version Upgrade
  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: