We’ve deployed the project to a folder in SSIS Catalog, now let’s create Environments and Environment Variables inside the SSIS Catalog:
Lesson Two. Deploying Projects in SSIS 2012 (Today’s class is longer than I expected, we’ll take a break and finish tomorrow.)
PreRequisite: Lesson One
By the end of this part of the lesson you should understand the following processes/terms.
- Building SSIS Projects
- Ispac files
- The SSIS Catalog
- Deploying ispac files
By the end of the second half of the lesson, the following will be covered:
- SSIS Catalog Environments
- SSIS Catalog Environment Variables.
- SSIS Executions
- Building Agent jobs with SSIS Catalog projects.
So you’ve got your Project with a Parent package. (by the way, you should designate Parent Packages as Entry Point packages inside a project by right clicking them and selecting “Entry Point Package”). You’ve got some child packages. You’ve got some variables. You’ve got project level parameters for values which should be available to all packages inside a project (like say, a directory for importing/exporting files, a client to process, a business unit to process, etc. ) and you’ve got package parameters for values which need to be passed from parent packages to child packages. You’re ready to Build, Deploy and Execute in SSIS 2012 utilizing all of its new toys features.
Oooo shiny new SSIS Project—Ready for Deployment