SSIS Configuration Table in Project Deployment Model

• nialllinden

  SSC Enthusiast

  Points: 158

  More actions

  May 19, 2016 at 1:33 pm

  #307839

  I have 2008 SSIS packages I need to upgrade to SQL SERVER 2014 SSIS packages. In using VS 2013 with Microsoft Visual Studio Community 2013 and SQL Server Data Tools 12.0.41012.0

  Microsoft SQL Server Data Tools

  There are about 10 packages in the project. What I would like to do is use the project deployment method so I can just have 1 shared connection for each connection. But the old packages also use package configuration, and in particular use 'server type' configurations (ie looks at a SSISConfiguration table on the DB)

  Is it possible to still use these, as most of the documentation say to use package configurations you need to use package deploy mode, and when I upgraded in VS2013, the sql server configuration types seem to have been removed in some packages.

  My question is, in 2014 SSIS, is it possible to still use the same sort of package configurations (in particular those that use a 'sql server' configuration type in 'package configurations' but deploy using project mode so I can get the advantages of shared parameters and connections?

  Thanks

  N