1 / 10

SSAS(MSBI) Online Training@SQL SERVER MASTERS

SSAS(MSBI) Online Training@SQL SERVER MASTERS. SSAS(MSBI) Online Training@SQL SERVER MASTERS. Contact Us: Call:+91-9052666559 Mail:training@sqlservermasters.com Visit:www.sqlservermasters.com. Microsoft Business Intelligence(MSBI)Online Training. SQL Server2012Integration Services

pepper
Download Presentation

SSAS(MSBI) Online Training@SQL SERVER MASTERS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SSAS(MSBI) Online Training@SQL SERVER MASTERS

  2. SSAS(MSBI) Online Training@SQL SERVER MASTERS • Contact Us: • Call:+91-9052666559 • Mail:training@sqlservermasters.com • Visit:www.sqlservermasters.com

  3. Microsoft Business Intelligence(MSBI)Online Training SQL Server2012Integration Services Introduction to SQL Server Integration Services • Product History • SSIS Package Architecture Overview • Development and Management Tools • Source Control for SSIS Packages SSIS Using SSMS • The Import and Export Wizard • Importing and Exporting Data • Working with Packages • Database Maintenance Plans • Creating Database Maintenance Plans using SSMS

  4. SSAS(MSBI) Online Training@SQL SERVER MASTERS SQL Server Data Tools • Launching Data Tools • Project templates • The package designer • The Toolbox • Solution Explorer • The Properties window • The Variables window • The SSIS menu

  5. SSAS(MSBI) Online Training@SQL SERVER MASTERS 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 and other Control Flow Items. • Case Study on Usage of ControlFlow items.

  6. SSAS(MSBI) Online Training@SQL SERVER MASTERS Advanced Control Flow • Containers – grouping and looping • The Analysis Services tasks • The Execute Process Task • The Execute Package Task • Case Study on Usage of Execute Package Tasks for Zipping and Unzipping Files. • Case Study on Creation of Master and Child Packages using Execute Package Task.

  7. SSAS(MSBI) Online Training@SQL SERVER MASTERS • Introduction to Data Flow • Data Flow Overview • Data Sources • Data Destinations • Data Transformations overview • Commonly Used Transformations. • Case Study for usage of Transformations and Other Dataflow components.

  8. SSAS(MSBI) Online Training@SQL SERVER MASTERS 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. • Examples of usage of Variables and Usage of expressions. • Configuration Overview

  9. SSAS(MSBI) Online Training@SQL SERVER MASTERS Debugging, Error Handling and Logging • SSIS debugging overview • Breakpoints in SSIS • SSIS debugging windows • Control Flow: The OnError event handler • Data Flow: Error data flow • Configuring Package Logging. • Demonstration of Logging and Configurations using a Sample Case Study.

  10. Interesting, right? This is just a sneak preview of the full presentation. We hope you like it! To see the rest of it, just click here to view it in full on PowerShow.com. Then, if you’d like, you can also log in to PowerShow.com to download the entire presentation for free.

More Related