Below is the deference between package and project
deployment model
Project deployment model
|
Package deployment model
|
Project is deployed
|
Package is deployed
|
Project uses parameters
|
Package uses Configurations files/tables
|
Project is located in an .ispac file and packages have .dtsx
extensions
|
Packages have .dtsx extensions.
|
Project is deployed to integration service catalog.
|
Packages are deployed to the MSDB or File.
|
CLR Integration is required.
|
CLR integration is not required.
|
New environments in the SSIS catalog can be used with parameters.
|
System environment variables can be used with configuration.
|
Projects and packages can be validated before execution with T-SQL or
Managed code.
|
Packages are validated just before execution and can be validated
with dtexce or managed code.
|
Packages are executed with T-SQL. Parameters and environments can be
set with T-SQL.
|
Packages are executed with dtexe and dtexecui. Command parameters can
be passed to the command prompt.
|
Robust logging is built in with several report.
|
Logging is built in with no report.
|
