Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS SQL Server 2012 Expand / Collapse
Posted Thursday, February 7, 2013 3:28 PM


Group: General Forum Members
Last Login: Wednesday, July 1, 2015 4:26 PM
Points: 1,838, Visits: 3,403
We are using SQL server 2008 SSIS, currently we have configuration files for all our packages.
We are not using SQL server 2012 SSIS, but I would like to know if someone has used it, and does it still use configuration files for variables and connection strings?

If not, what does it use?

Post #1417374
Posted Thursday, February 7, 2013 6:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 2, 2015 8:54 AM
Points: 49, Visits: 401
Hi, SSIS 2012 has two deployment models: Package deployment model and Project deployment model.

If you use package dep. model, you can continue to use configuration files just like you'd use with SSIS 2008 and previuos version. The drawback is, you'll not be able to use several new and improved features that come in 2012 like the SSIS Catalog database and logging.

If you use project deployment model, you can't use configuration files. You've to plan on a full fledged migration.

Sam Vanga
Post #1417416
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse