|
Formål:
At give deltageren viden om at installere Integration Service løsninger i en organisation. En gennemgang af hvordan man via værktøjer skaber mulighed for at samle data fra mange kilder.
Forudsætninger:
Følgende kurser eller tilsvarende viden:
- SU-240 SQL Programmering Grundkursus
samt
- SU-241 SQL Programmering Videregående (fordel)
- SU-242 MS Transact SQL (T-SQL) Programmering (fordel)
- MS-6231 Maintaining a Microsoft SQL Server 2008 Database (fordel)
- MS-6232 Implementing a Microsoft SQL Server 2008 Database (fordel
Beskrivelse:
Kurset gennemgår hvordan Integration Services implementeres i en organisation. Oprettelse og både kontrol- og data-flow i Integration Services pakker. Logning samt debug og fejlhåndtering i Integration Services pakker. Gennem checkpoint på transaktioner, sikres at data er valide til behandlingen. Endelig behandles deployment, administration og sikkerhed af Integration Services pakker.
Lærebøger:
Microsoft Official Curriculum (MOC) materiale.
Certificeringer:
- 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (En del af testen)
Varighed / Pris:
3 dage / 11.100,- kr. (ekskl. moms)
Videre forløb:
- MS-6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
|
Indhold:
- Introduction to SQL Server 2008 Integration Services
- Overview of SQL Server Integration Services
- Using Integration Services Tools
- Developing Integration Services Solutions
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
- Implementing Control Flow
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
- Implementing Data Flow
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
- Implementing Logging
- Overview of Integration Services Logging
- Enabling and Configuring Logging
- Debugging and Error Handling
- Debugging a Package
- Implementing Error Handling
- Implementing Checkpoints and Transactions
- Implementing Checkpoints
- Implementing Transactions
- Configuring and Deploying Packages
- Package Configurations
- Deploying Packages
- Managing and Securing Packages
- Managing Packages
- Securing Packages
|
