1. Floating Topic
2. Package Variables
   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
3. Data Flow
   1. Adapters
      1. Destination
         1. Types
            1. ADO.NET Destination
            2. Data Mining Model Training
            3. Data Reader Destination
            4. Stored as record set
            5. can be programically referenced
            6. Dimension Processing
            7. Excel Destination
            8. FlatFile Destination
            9. OLE DB Destination
            10. Partition Processing
            11. Raw File Destination
            12. SSIS Binary destination
            13. Native SSIS Binary
            14. Used in staging
            15. Record Set Destination
            16. Data stored in a record set
            17. stored as an object
            18. SQL Server Compact Destination
            19. Send to SQL SERVER
            20. Sends to mobile devices
            21. SQL Server Destination
         2. Where data is pushed
      2. Source
         1. Types
            1. ADO.NET source
            2. Uses ADO.NET
            3. Connects to
            4. Queries
            5. Tables
            6. Excel Source
            7. from worksheet
            8. Flat File Source
            9. Fixed width file
            10. Comma delimited file
            11. OLE DB Source
            12. connects to OLE DB
            13. OLE DB types
            14. SQL Server
            15. Access
            16. SSAS
            17. Oracle
            18. Raw File Source
            19. Binary data
            20. Used for staging
            21. XML Source
            22. Require XML schema file
            23. extracts
            24. Raw data
            25. from XML file
         2. Purpose
            1. Extract data
            2. Flat files
            3. Excel
            4. Databases
            5. Add data to data flow
   2. Transformations
      1. Types
         1. Logical row level
            1. Types
            2. Audit
            3. Cache Transform
            4. Character map
            5. Copy column
            6. Data Conversion
            7. Derived Column
            8. Export column
            9. Import column
            10. Row count
            11. Uses
            12. Mathmatical
            13. Conversions
            14. Text to numeric
            15. Text to decimal
            16. Replacing NULLs
            17. Import/Export column
            18. Needs Large binary files
            19. increased workload
         2. multi input or multi output
            1. Types
            2. Conditional Split
            3. Lookup
            4. Merge
            5. Merge Join
            6. Multicast
            7. Union All
            8. Uses
            9. Combine Data
            10. Branch data
            11. Multiple sources to multiple destinations
         3. Multi Row
            1. Types
            2. Aggregate
            3. Percent Sampling
            4. Pivot
            5. Row Sampling
            6. Sort
            7. Unpivot
            8. Uses
            9. Use criteria from multiuple rows
            10. create multiple rows from single row
            11. Memory intensive tasks
         4. Advanced data preparation
            1. Types
            2. OLE DB Command
            3. Slowly Changing Dimension
            4. Data Mining Query
            5. Fuzzy Grouping
            6. Fuzzy Lookup
            7. Script Component
            8. Term Extraction
            9. Term Lookup
            10. Uses
            11. Transforms rows in pipeline
      2. Using
4. Control Flow
   1. Tasks
      1. Configuration
         1. Configure by right clicking task
         2. Done through the editor
      2. Task Types
         1. ActiveX Script Task
         2. Analysis services Execute DDL Task
         3. Analysis Services Processing
         4. Bulk Insert Task
         5. Data Flow Task
         6. Data Mining Query
         7. Data Profiling
            1. Purpose
            2. Review Source
            3. Understand Organization
            4. Checks
            5. Cleanliness
            6. Completeness
            7. Using
            8. Create Connection
            9. Drag control flow item
            10. Edit Properties
            11. Profiles
            12. Column null ratio
            13. Column statistics
            14. Column value distribution
            15. Column length distribution
            16. Column Pattern
            17. Candidate Key
            18. Functional Dependency
            19. Output
            20. In XML File
            21. Destination Property
            22. Reading
            23. Use profile viewer
         8. Execute DTS 2000 Package
         9. Execute Package
         10. Execute Process
         11. Execute SQL
         12. File System Task
         13. FTP Task
         14. Message Queue Task
         15. Script Task
             1. Execute in
             2. VB.net
             3. C#
             4. Variables
             5. Reffrenced
             6. Updated
             7. Permissions
             8. Read only
             9. Read write
             10. Defined in script editor
             11. Break Points
         16. Send Mail Task
         17. Transfer [Objects] Task
         18. Web Service tasks
         19. WMI Data Reader Task
         20. WMI Event Watcher
         21. XML 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
5. Error Handling
   1. Transactions
   2. Checkpoints
   3. Subtopic 3
6. T SQL
   1. Statements
      1. succesfull or not
      2. refered to as transactions