September 2012
Beginner to intermediate
672 pages
21h 25m
English
book
Microsoft® SQL Server® 2012 Integration Services
by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Content preview from Microsoft® SQL Server® 2012 Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 6. Developing an SSIS Solution
SSIS Project Deployment Models
When developing an SSIS Project in SQL Server 2012, you can use either the Package Deployment Model or the Project Deployment Model. The Project Deployment Model determines the set of SSIS features that you can use when working with SSIS projects. The Project Deployment Model is the default deployment model when a new Integration Services project is created. When you upgrade from an existing SSIS project, the project will use the Package Deployment Model. Using SQL Server Data Tools, you can convert from the Package Deployment Model to the Project Deployment Model (or vice versa).