SSIS can be installed during the SQL Server installation or as a separate component. Before installation, there are a number of factors needing consideration, such as upgrade options and architecture. This course will cover SSIS components.
Learning Objectives
Components of SSIS
- start the course
- describe SSIS components
- prepare to install integration services
- recognize the various SSIS configurations
- install integration services using the setup wizard
- use the SSIS designer graphical tool
- describe when and how to use the development box and server
- install specifics for remote package execution
- plan for a 64-bit installation
- upgrade SSIS components
- provision accounts
- create the catalog
- describe catalog object identifiers
- configure a catalog
Practice: Installing Integration Services
- install integration services using the setup wizard