MicroSoft SSIS Training

MicroSoft SSIS Syllabus

 

  • SSIS Introductions
  • Control Flow
  • Data Flow
  • Precedence constraint & Expressions
  • Sequence Container
  • Annotation
  • Data Flow Components
  • Data viewer
  • Copy
  • OLEDB Source
  • OLDB Destination
  • Audit
  • Character Map
  • Conditional Split
  • Row sampling
  • Percentage sampling
  • Excel Source
  • Flat File Source
    • Control Flow Components
    • Sequence Containers
    • For loop
    • For each loop
  • Variables with default values
  • Variables with dynamic values through Expressions
  • Dynamic loading of Excel files into SQL target
  • FTP Task
  • Execute SQL Task – Basic
  • Execute SQL task with parameter and with result
  • Multicast
  • Data conversion / Type Cast
  • Sort
  • Merge
  • Union all
  • Aggregate
  • Derived
  • Row Count
  • Breakpoints
  • Merge join
  • Flat File Destination
  • Excel Destination
  • OLEDB Command
  • Cache transformation (target is cashed)
  • Lookup
  • SCD (type 1, type 2)
  • Breakpoints
  • Script task
    • Bulk Insert Task (sending FF – SQL)
    • Execute package
    • Execute process
  • ERROR Output in DF
  • File system Task
  • Send Mail Task
  • Logging
  • Checkpoints (restart ability)
  • Jobs (Scheduling)
  • Deployment
    • Configurations
Quick Enroll