Skip to main content
SQL Server
Sign in
United States (English)
Home 2012 2008 R2 2008 Previous Versions Library Forums

SQL Server Integration Services "How do I?" Videos

 

In this video, I’ll demonstrate how to perform change data capture (CDC) for Oracle databases using the new features introduced in SQL Server 2012 Integration Services (SSIS). You’ll learn how CDC for Oracle works, how to create a CDC service and administer the service, as well as monitor the logs and traces to troubleshoot the service.

Change Data Capture (CDC) for Oracle Databases using SQL Server Integration Services 2012 (SQL Server Video)
(16:24)

In this video, I'm going to demonstrate how to leverage the Balanced Data Distributor component to reduce the execution time of an SSIS package. You'll learn how to increase the throughput of the package Data Flow transformations by paralleling the Data Flow buffers to multiple outputs.

Balanced Data Distributor
(10:29)

In this video, I'm going to demonstrate how to use the SSIS Log Analyzer tool to analyze complex and verbose SSIS logs quickly and easily.

SSIS Log Analyzer (SQL Server Video)
(08:30)

 

This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow: 1) Extraction; 2) Transformation; 3) Loading. You can apply these performance tuning tips when you design, develop, and run the data flow.

Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video)
(24:01)

This video demonstrates how to troubleshoot an SQL Server Integration Services package that doesn't run when you call the package from a SQL Server Agent job step. The package does run successfully outside SQL Server Agent.

Troubleshooting: SSIS Package Execution Using SQL Server Agent (SQL Server Video)
(12:24)

This video demonstrates the following: 1) How to create a proxy account that runs an Integration Services package as a job step in SQL Server Agent; 2) How to create the job and the job step; 3) How to schedule the running of the job.

How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)?
(10:21)

 

This video demonstrates how to create a basic package by using the SSIS Designer in Business Intelligence Development Studio. You’ll learn how to create the project for the package, add a data flow task to the control flow of the package, and add elements to the data flow.

Creating a Basic Package (SQL Server Video)
(08:07)

Many organizations have both Oracle and SQL Server databases. In this video Scott Golightly shows how easy it is to use the import data wizard and SQL Server Integration Services to import data from a table in an Oracle database into SQL Server.

How Do I: Import Data from Oracle Databases
(08:07)

This video demonstrates how to increase the performance of your Integration Services packages by designing for parallelism.

How Do I: Import Text Files with SQL Server Integration Services
(09:48)

 

This video demonstrates how to implement a Lookup transformation in Full Cache mode by using a Lookup transformation, Cache connection manager, and reference data set that is stored in cache.

How to: Implement a Lookup Transformation in Full Cache Mode (SQL Server Video)?
(09:46)

This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet.

Exporting SQL Server Data to Excel (SQL Server Video)?
(08:13)

Learn how to call a Web service successfully from an Integration Services package by configuring an HTTP connection manager and the Web Service task. Then, set up an XML task to read the information that you have retrieved, and use that information in the package.

How to: Call a Web Service by Using the Web Service Task (SQL Server Video)?
(11:10)

 

More Videos

  • Analysis Services
  • Data Mining
  • Data Quality Services
  • Master Data Services
  • PowerPivot
  • Report Builder
  • Reporting Services
  • SQL Server

© 2013 Microsoft
  • Manage Your Profile
  • Newsletter
  • Contact Us
  • Privacy Statement
  • Terms of Use
  • Trademarks
  • | Site Feedback
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows
    Server
  • System
    Center
  • Internet
    Explorer
 
  • Office
  • Office 365
  • Exchange
    Server
 
  • SQL Server
  • SharePoint
    Products
  • Lync
  • See all products »
Resources
  • Evaluation Center
  • Learning Resources
  • Microsoft IT Camps
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • Solution Accelerators
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Subscriptions
  • TechNet Video
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Microsoft Update
Trials
  • Windows Server 2012
  • System Center 2012 SP1
  • Microsoft SQL Server 2012 SP1
  • Windows 8 Enterprise
  • See all trials »
Related Sites
  • Microsoft Download Center
  • TechNet Evaluation Center
  • Drivers
  • Compatability & Converters
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • e-Learning overview
Certifications
  • Certification overview
  • MCSA: Windows 8
  • Windows Server Certification (MCSE)
  • Private Cloud Certification (MCSE)
  • SQL Server Certification (MCSE)
Other resources
  • TechNet Events
  • Second shot for certification
  • Born To Learn blog
  • IT Camps
Support by product
  • Exchange Server
  • Forefront Server
  • Forefront Edge Security
  • Forefront Server Security
  • Internet Explorer
  • Office
  • SharePoint
 
  • SQL Server
  • System Center
  • Windows Server
  • Windows XP
  • Windows Vista
  • Windows 7
  • Windows 8
Other support links
  • Microsoft Premier Online
  • Microsoft Fix It Center
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
  • International support solutions
  • Log a support ticket
  • Look up event IDs and error codes
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums