SQL Server 2005 Integration Services - Lookup Transformation - Part 33

Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.

Integrating Database Snapshots into Integration Services

Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.

File Watcher Task

The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.

Using Transactions in SSIS

In SSIS demostration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.

Using the For Each ADO Enumerator

In this video, you'll learn how to use the For Each ADO enumerator in SSIS to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client dynamically.

Clustering SSIS

By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.

SQL Server 2005 Integration Services - Message Queue Task - Part 32

After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, part 32 of this series focuses on individual components that have more specialized, but very useful characteristics, starting by discussing the Message Queue Control Flow task, and following with coverage of a number of Data Flow transformations.

Looping Through and Loading Files with SSIS

In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.

SQL Server 2005 Integration Services - Performance - Part 30

The superiority of SSIS over DTS goes beyond functionality alone, providing numerous efficiency benefits, which we will present in more detail in this article.

Which of the following is not true about...