0
Lynda.com Video Eğitim Seti - SQL Server Bütünleşme Hizmetleri - İngilizce
(SQL Server Integration Services)
- Version changes of SSIS from 2008-2014
- The SQL Server Integration Service
- Understanding packages
- Managing with control flow
- Moving data with data flow
- Understanding variables
- Understanding parameters
- Utilizing the Import and Export Wizards
- Working in the Explore window
- Creating SQL Server Integration Services packages
- Utilizing connection managers
- The Source and Destination Assistants
- Coding the Script task
- Looping and Sequence tasks
- Data Preparation tasks
- Data loading with the Execute SQL task
- Using the Workflow tasks
- Managing SQL with the SQL tasks
- Administration of SQL using the SQL Management Objects tasks
- Using destinations and understanding choices
- Examining the Row transformations
- Examining the Rowset transformations
- Examining Split and Join transformations
- SQL Server Integration Services data typing
- Defining and using variables and parameters
- Using expressions to make dynamic packages
- Performing joins with the Lookup transformation
- Performing joins with the Merge transformation
- Designing to troubleshoot - Using precedence constraints
- Using events
- Working with logging
- Handling errors
- Choosing the Script task or Script component
- Working with XML
- Deployment