Database Reference
In-Depth Information
Figure 18-4 . Converting to the Package Deployment Model
Note When using the Package Deployment Model, you will not be able to use some
of the new functionality introduced in SQL Server 2012, such as Parameters and Project
References. If any of your packages are using these features, SSDT-BI will not let you
convert to the Package Deployment Model.
Table 18-2 lists the deployment locations you would use with the Package Deploy-
ment Model, and briefly describes the advantages of each approach.
Table 18-2 . Deployment locations when using the Package Deployment Model
Location
Notes
File System
• Mirrors the structure you have when developing in SSDT-BI
• Doesn't require database permissions
• Deployment is a simple file copy
SQL Server
(MSDB)
• Backup and maintenance part of regular SQL functionality
• Finer control over package access and security
 
 
 
Search WWH ::




Custom Search