Thursday 14 July 2016

Difference between Package and Project Deployment Model

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.


3 comments:

  1. I am thankful to this blog for assisting me. I added some specified clues which are really important for me to use them in my writing skill. Really helpful stuff made by this blog.
    HPE ProLiant DL180 Gen9

    ReplyDelete
  2. Your writing skill was amazing you briefly described your article, thanks for this information.

    instadp

    ReplyDelete

If you have any doubt, please let me know.

Popular Posts