SSIS

• Introduction
• Data Flow Items
• Data Flow Source
• Flat File Source
• OLE DB Source
• Excel Source
• ADO NET Source
• XML Source
• Raw File Source
•  Data Flow Transformations
• Aggregate
• Audit
• Character Map
• Conditional Split
• Data Conversion
• Derived Column
• Fuzzy Grouping
• Fuzzy Lookup
• Lookup
• Merge
• Merge Join
• Multicast
• OLE DB Command
• Row Count
• Slowly Changing Dimension
• Sort
• Union All
• Pivot
• Unpivot 
• Data Flow Destination
• Flat File Destination
• OLE DB Destination
• Excel Destination
• ADO NET Destination
• Raw File Destination
• Control Flow Items
• Tasks
• Data Flow Task
• Execute Package Task
• FTP Task
• File System Task
• Bulk Insert Task
• Execute Process Task
• Execute SQL Task
• Send Mail Task
• Script Task 

• Containers:
• Foreach Loop Container
• For Loop Container
• Error Handling
  
  • Control flow level error handling:
• Loging or Log file creation
• Event Handlers
• Check points
• Precedence Constraints

•  Data flow level error handling:

• Error output or Redirect row

•  Security
• Config file creation
• Setting Production level 
• Package Deployment
• File System Deployment
• SQL Server Deployment

• Scheduling

• Best Practice Methods
•  Avoid Sort Transformation

• SSIS Scenarios
• Get Source File path from a SQL Table and Process the file
• Writing Expression for Variables
• Create a folder with current date
• Run a SSIS Package Using Batch File