MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Integration Services Fundamentals

Course Summary

This course explains how to develop Integration Services packages with an emphasis on the development of processes that support data warehousing. It begins by describing the overall process of package development, then describes the types of tasks that In


  • +

    Course Syllabus

    ● Introduction to Integration Services
        ◦ Introduction to Integration Services
        ◦ Architecture
        ◦ Package Development
        ◦ Integration Services Projects in BIDS
        ◦ Demo: Creating a Package in BIDS with the Import and Export Wizard
        ◦ Package Designer
        ◦ Introduction to Connection Managers
        ◦ Introduction to Package Execution
        ◦ Demo: Exploring a Package
        ◦ Demo: Exploring a Package
        ◦ Summary
    ● Control Flow Basics
        ◦ Control Flow Basics
        ◦ Connection Managers
        ◦ 32-bit versus 64-bit Providers
        ◦ Demo: Creating a Connection Manager
        ◦ Tasks
        ◦ Demo: Creating an Execute SQL Task
        ◦ Demo: Creating a Send Mail Task
        ◦ Precedence Constraints
        ◦ Demo: Adding Precedence Constraints
        ◦ Containers
        ◦ Demo: Working with Containers
        ◦ Summary
    ● Control Flow Tasks
        ◦ Control Flow Tasks
        ◦ Data Preparation Tasks
        ◦ Demo: File System Task
        ◦ Demo: FTP Task
        ◦ Demo: Web Service Task
        ◦ Demo: XML Task
        ◦ Demo: Data Profiling Task
        ◦ Demo: Data Profiling Viewer
        ◦ Process Communication Tasks
        ◦ Demo: Message Queue Task - Send
        ◦ Demo: Message Queue Task - Receive
        ◦ Demo: Execute Package Task
        ◦ Demo: WMI Data Reader Task
        ◦ Demo: WMI Event Watcher Task
        ◦ Demo: Execute Process Task
        ◦ SQL Server Tasks
        ◦ Demo: Bulk Insert Task
        ◦ Analysis Services Tasks
        ◦ Demo: Analysis Services Processing Task
        ◦ Demo: Analysis Services Execute DDL Task
        ◦ Demo: Data Mining Query Task
        ◦ Database Maintenance Tasks
        ◦ Summary
    ● Data Flow Basics
        ◦ Data Flow Basics
        ◦ Data Flow Task
        ◦ Pipeline Architecture
        ◦ Data Sources
        ◦ Demo: ADO.NET Source
        ◦ Demo: Excel Source
        ◦ Demo: Flat File Source
        ◦ Demo: OLE DB Source
        ◦ Demo: XML Source
        ◦ Demo: Raw File Destination
        ◦ Demo: Raw File Source
        ◦ Data Destinations
        ◦ Demo: OLE DB Destination
        ◦ Demo: DataReader Destination / Run64BitRuntime Property
        ◦ Demo: Excel Destination / Override Connection Manager Data Types
        ◦ Demo: Flat File Destination
        ◦ Demo: SQL Server Destination
        ◦ Analysis Services Destinations
        ◦ Demo: Dimension Processing
        ◦ Demo: Partition Processing
        ◦ Demo: Data Mining Model Training
        ◦ Summary
    ● Data Flow Transformations
        ◦ Data Flow Transformations
        ◦ Row Transformations
        ◦ Demo: Character Map
        ◦ Demo: Copy Column
        ◦ Demo: Data Conversion
        ◦ Demo: Derived Column
        ◦ Demo: OLE DB Command
        ◦ Rowset Transformations
        ◦ Demo: Aggregate
        ◦ Demo: Sort
        ◦ Demo: Unpivot
        ◦ Demo: Pivot
        ◦ Demo: Percentage Sampling
        ◦ Demo: Row Sampling
        ◦ Split and Join Transformations
        ◦ Demo: Conditional Split
        ◦ Demo: Multicast
        ◦ Demo: Union All
        ◦ Demo: Merge
        ◦ Demo


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top