SQL Server 2012 SSIS Course in London, UK
Only 500 Pounds...Only
A Guided Tour of Integration Services
- Understanding Integration Services
- Exploring and Executing an Integration Services Packages in BIDS
- Exploring and Executing a Package Outside of BIDS
Introduction to Control Flow
- Overview of Control Flow in Integration Services
- Elements in Control Flow
- Control Flow Tasks
- Working with Workflow Tasks
- Precedence Constraints
Introduction to Data Flow
- Data Flow Overview
- Data Flow Pipeline
- Data Flow Sources
- Data Flow Destination
- Data Viewers
- Data Transformations
Variables and Configurations
- Understanding Variables
- Using Variables in Control Flow
- Using Variables in Data Flow
- Understanding Property Expressions
- Using Property Expressions
- Understanding Configurations
- Using Configurations
- Using Variables and Configurations between Packages
Error Logging and Handling
- Error Logging and Handling Overview
- Checkpoints
- Package Logging
- Event Handling
Package Deployment
- Overview of Deploying Packages
- Deployment Challenges
- Create a Package Deployment Utility
- The Package Installation Wizard
- Deploy a Package to the File System
- Deploy a Package to SQL Server
- Importing a Package Using Management Studio
- Redeploying Update Packages
Package Management
- Overview of Package Management
- Managing Packages with DTUtil
- Managing Packages with SQL Server Management Studio
- Executing Packages
- Scheduling Packages with SQL Server Agent
- Integrati
What are the differences between BI & Datawarehouse?
The differentials are:
DW - is a way of storing data and creating information through leveraging data marts. DM's are segments or categories of information and/or data that are grouped together to provide 'information' into that segment or category. DW does not require BI to work. Reporting tools can generate reports from the DW.
BI - is the leveraging of DW to help make business decisions and recommendations. Information and data rules engines are leveraged here to help make these decisions along with statistical analysis tools and data mining tools.