Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

SSIS

No Reviews Yet

Course type: Online Instructor led Course

Platform: Online Meeting

Course ID: 24870

Course type: Online Instructor led Course

Platform: Online Meeting

Students Interested 1 (Seats Left 0)

₹ 5,000

No Reviews Yet

Date and Time

Not decided yet.

Veeren Chowdary

BTECH with 8 years experience

About Veeren Chowdary

I am working in Product based company and I was in core MS BI frame work team for more than 8 years.

If you are looking for MSBI online and class room trainings with expert level course details and MDX,DAX topics with real Data engineering projects and interview tips and certifications please join my courses.
No reviews currently

About the Course

ETL , DW , SSIS SQL Server 2008,2008R2,2012 Business Intelligence

Topics Covered

SQL Server Integration Services
Introduction to SQL Server Integration Services
• SSIS Architecture Overview
• Development and Administration Tools
• The Import and Export Wizard
Hey what is Business Intelligence Development Studio
Introduction to Data Flow
• Data Flow Overview
• Data Sources
• Data Destinations
• Data Flow Transformations
• Data Viewers
Data Sources
• Excel Source
• Flat File Source
• OLE DB Source
• XML Source
Data Flow Transformations
• Aggregate Transformation
• Audit Transformation
• Character Map Transformation
• Conditional Split Transformation
• Copy Column Transformation
• Derived Column Transformation
• Data Conversion Transformation
• Multicast Transformation
• OLE DB Command Transformation
• Percentage Sampling Transformation
• Row Count Transformation
• Sort Transformation
• Union All Transformation
Advanced Data Flow
• Lookup Transformation
• Merge Transformation
• Merge Join Transformation
• Slowly Changing Dimension Transformation
• Pivot Transformation
• Export Transformation
• Import Transformation
• Unpivot Transformation
Data Flow Destinations
• Data Reader Destination
• Excel Destination
• Flat File Destination
• OLE DB Destination
Introduction to Control Flow
• Control Flow Overview
• Precedence Constraints
• The Execute SQL Task
• The Bulk Insert Task
• The File System Task
• The FTP Task
• The Send Mail Task
• Bulk Insert Task
• Data Flow Task
• Execute DTS 2000 Package Task
• Execute Package Task
• Execute Process Task
• Web Service Task
• XML Task
Advanced Control Flow
• For Loop Container
• For Each Loop Container
• Sequence Container
Variables and Configurations
• Variables Overview
• Variable scope
• SSIS system variables
• Using variables in control flow
• Using variables in data flow
• Using variables to pass information between packages
• Property expressions
• Configuration Overview
• Configuration options
• Configuration discipline
Debugging, Error Handling and Logging
• SSIS debugging overview
• Breakpoints in SSIS
• Control Flow: The On Error event handler
• Data Flow: Error data flow
• Configuring Package Logging
• Built-in log providers
Extending SSIS through Custom Code – Scripting
• Introduction to SSIS scripting
• The SSIS script editor
• The SSIS object model
• Script in Control flow: The Script Task
• Script in Data flow: The Script Component
• Introduction to SSIS component development
SSIS Package Deployment
• Configurations and deployment
• The deployment utility
• Deployment options
• Deployment security
• Executing packages – DTExec and DTExecUI
SSIS Package Management
• The SSIS Service
• Managing packages with DTUtil
• Managing packages with SQL Server Management Studio
• Scheduling packages with SQL Server Agent

Who should attend

Who seek SQL Server Development career

Pre-requisites

Basic SQL Server

What you need to bring

Laptop or Desktop with Mic and Headset"

Key Takeaways

Weekly Materials and Bi framework implementation

Reviews

No reviews currently

Discussions

Students Interested 1 (Seats Left 0)

₹ 5,000

Post your requirement and let us connect you with best possible matches for Microsoft BI (Business Intelligence) Tools Training Post your requirement now
₹ 5,000 Enquire