Course Duration in Hours
30
30
Course Contents
Introduction to Integration Services
Defining SQL Server Integration Services
Exploring the need for migrating diverse data
The role of business intelligence (BI)
SSIS Architecture and Tools
Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
Running wizards for basic migrations
Creating packages for complex tasks
Distinguishing between data flow pipeline and package runtime
Executing packages on the client side or hosted in the SSIS service
Implementing Tasks and Containers
Configuring connection managers
Adding data flow tasks to packages
Reviewing progress with data viewers
Assembling tasks to perform complex data migrations
Migrating multiple files with FOREACH container
Copying, moving and deleting files
Transferring files with the FTP task
Communicating with external sources
Sending messages through mail
Extending Capabilities with Scripting
Extending functionality with the Script Task
Debugging, breakpoints, watches
Transforming with the Data Flow Task
Converting and calculating columns
Transforming with Character Map
Profiling data
Merge, Union, Conditional Split
Multicasting and converting data
Executing a SQL task
Bulk inserting data from text files
Error Handling, Logging and Transactions
Defining success, failure, completion and expression precedence constraints
Handling events and event bubbling
Choosing log providers
Adapting solutions with package configurations
Auditing package execution results
Any Graduate
enosis learning, Viman Nagar (Pune),Pune,IN