Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Mar 20th @10:00PM

Faculty: Mr. Shekhar (15+ Yrs of Exp,.. & Real Time Expert)

Duration: 20 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96

Syllabus:

SSIS
(SQL SERVER Integration Services)

Introduction to SQL Server Integration Services

• SSIS Historical Overview
• SSIS Architecture
• Tools of the Trade
• Creating a Simple Package
• Practice

SSIS Tools

• Import and Export Wizard
• SQL Server Data Tools
• SQL Server Management Studio

SSIS Tasks

• Looping and Sequence Tasks
• Data Flow Task
• Data Preparation Tasks
• Workflow Tasks
• Administration Tasks
• Execute Package Task
• Script Task

Working with Containers

• Sequence Containers
• For Loop Container
• Foreach Loop Container 

The Data Flow

• Understanding the Data Flow
• Sources & Destinations
• Common Transformations

Using Variables, Parameters and Expressions

• Dynamic Package Objects
• Understanding Data Types
• Using Variables and Parameters
• Working with Expressions 

Accessing Heterogeneous Data

• The Connection Managers
• Excel and Access
• Oracle
• Using XML and Web Services
• Flat Files
• Other Heterogeneous Sources
• Practice

Error and Event Handling

• Package Transactions
• Using Precedence Constraints
• Event Handling
• Breakpoints
• Error Rows
• Logging
• Practice

SSIS Administration

• Deployment Models
• Package Configuration
• Security
• Scheduling Packages
• Monitoring Package Executions
• Practice