1. Package Varables
   1. Variable types
      1. System Variables
         1. Not Editable
         2. Refferenced in
            1. Containers
            2. Tasks
         3. Viewing
            1. System variable buttom
            2. Variable window toolbar
         4. Set by meta data
      2. User Variables
         1. Used in looping
            1. Defined in loop editor
            2. Use Mapping tab
   2. Variable elements
      1. Name
      2. Scope
         1. Package Level
         2. Task Level
         3. Container Level
      3. Data Type
      4. Value
   3. Purposes
      1. Pass values
         1. Intenral and external
         2. Tasks and containers
      2. Dynamic Code
      3. Auditing
      4. Logging
   4. Variable window
2. Control Flows
   1. Tasks
      1. Configuration
         1. Configure by right clicking task
         2. Done through the editor
      2. ActiveX Script Task
      3. Parralel Tasks
      4. Object level Jobs
   2. containers
      1. Grouping
         1. Apply Transaction to group
         2. Apply logging to group
      2. Container Types
         1. Sequence
            1. Subortinate Tasks
            2. Organize tasks
         2. For Loop
            1. Requires condition
            2. Run based on evaluation
         3. For Each loop
            1. action applied to each element
            2. Used in sets
            3. Tables
            4. Files
            5. Folders
            6. Configure
            7. Define User Variables
            8. Objects to loop
   3. Constraints
      1. Execution Precedence
      2. Execution Ordering
3. Control Flow Task Types
   1. Analysis services Execute DDL Task
   2. Analysis Services Processing
   3. Bulk Insert Task
   4. Data Flow Task
   5. Data Mining Query
   6. Data Profiling
      1. Purpose
         1. Review Source
         2. Understand Organization
         3. Checks
            1. Cleanliness
            2. Completeness
      2. Using
         1. Create Connection
         2. Drag control flow item
         3. Edit Properties
      3. Profiles
         1. Column null ratio
         2. Column statistics
         3. Column value distribution
         4. Column length distribution
         5. Column Pattern
         6. Candidate Key
         7. Functional Dependency
      4. Output
         1. In XML File
         2. Destination Property
      5. Reading
         1. Use profile viewer
   7. Execute DTS 2000 Package
   8. Execute Package
   9. Execute Process
   10. Execute SQL
   11. File System Task
   12. FTP Task
   13. Message Queue Task
   14. Script Task
       1. Execute in
          1. VB.net
          2. C#
       2. Variables
          1. Reffrenced
          2. Updated
          3. Permissions
             1. Read only
             2. Read write
             3. Defined in script editor
       3. Break Points
   15. Send Mail Task
   16. Transfer [Objects] Task
   17. Web Service tasks
   18. WMI Data Reader Task
   19. WMI Event Watcher
   20. XML Task
4. Error Handling
   1. Transaction
      1. Values
         1. Success
         2. Failure
      2. Must be enabled
         1. In Package
            1. TransactionOption
            2. Requred
            3. If needed
            4. NotSupported
            5. Prevents
            6. used in inherency
            7. Parents will inherit
            8. Set for container
         2. For Server
            1. MSTC Service started
         3. For Each Loop
            1. Instance for each looping
      3. Definition
         1. Basic unit of work
         2. Atomic unit
      4. Uses
         1. Checkpoints
      5. Level
         1. Use at Control flow
         2. not used in data flow
   2. Checkpoints
5. Data Flow
6. Transformation Types
   1. Logical Row Level
      1. Audit
      2. Cache Transform
      3. Character map
      4. Copy column
      5. Data Conversion
      6. Derived Column
      7. Export column
      8. Import column
      9. Row count
      10. Types
      11. Uses
          1. Mathmatical
          2. Conversions
             1. Text to numeric
             2. Text to decimal
          3. Replacing NULLs
          4. Import/Export column
             1. Needs Large binary files
             2. increased workload
   2. Multi Input or output
      1. Conditional Split
      2. Lookup
      3. Merge
      4. Merge Join
      5. Multicast
      6. Union All
      7. Uses
         1. Combine Data
         2. Branch data
         3. Multiple sources to multiple destinations
   3. Multiple Row
      1. Aggregate
      2. Percent Sampling
      3. Pivot
      4. Row Sampling
      5. Sort
      6. Unpivot
      7. Uses
         1. Use criteria from multiuple rows
         2. create multiple rows from single row
         3. Memory intensive tasks
   4. Advanced Data Preperation
      1. Types
         1. OLE DB Command
         2. Slowly Changing Dimension
         3. Data Mining Query
         4. Fuzzy Grouping
         5. Fuzzy Lookup
         6. Script Component
         7. Term Extraction
         8. Term Lookup
      2. Uses
         1. Transforms rows in pipeline
7. Adapter Types
   1. Source
      1. Types
         1. ADO.NET source
            1. Uses ADO.NET
            2. Connects to
            3. Queries
            4. Tables
         2. Excel Source
            1. from worksheet
         3. Flat File Source
            1. Fixed width file
            2. Comma delimited file
         4. OLE DB Source
            1. connects to OLE DB
            2. OLE DB types
            3. SQL Server
            4. Access
            5. SSAS
            6. Oracle
         5. Raw File Source
            1. Binary data
            2. Used for staging
         6. XML Source
            1. Require XML schema file
            2. extracts
            3. Raw data
            4. from XML file
      2. Purpose
         1. Extract data
            1. Flat files
            2. Excel
            3. Databases
         2. Add data to data flow
   2. Destination
      1. Types
         1. ADO.NET Destination
         2. Data Mining Model Training
         3. Data Reader Destination
            1. Stored as record set
            2. can be programically referenced
         4. Dimension Processing
         5. Excel Destination
         6. FlatFile Destination
         7. OLE DB Destination
         8. Partition Processing
         9. Raw File Destination
            1. SSIS Binary destination
            2. Native SSIS Binary
            3. Used in staging
         10. Record Set Destination
             1. Data stored in a record set
             2. stored as an object
         11. SQL Server Compact Destination
             1. Send to SQL SERVER
             2. Sends to mobile devices
         12. SQL Server Destination
      2. Where data is pushed
8. Checkpoints
   1. Purpose
      1. Restart in case of failure
   2. used in
      1. Complicate packages
      2. Long Packages
   3. Properties
      1. SaveCheckpoints
      2. CheckpointFileName
      3. CheckpointUsage
9. Intergation Services (SSIS)
10. Analysis Services
11. Reporting Services
12. Main Topic 4