Removing Duplicates Rows with SSIS Sort Transformation

Source:

Using Sequence in a Control Flow

Source:How to transaction rollback in ssis?

...

By using Sequence Containers (Sequence, For Loop, ForEach Loop) in SSIS, you can make use of a property called TransactionOption. This allows you to specify the transactional behaviour of the tasks in your package, and the package itself to rollback if any tasks fail.

For example, if you stick your tasks in a Sequence Container and set TransactionOption=Required, and configure all Tasks within the Container to TransactionOption=Supported, they will all join the transaction started in the Sequence Container, and if any fail, the transaction will be rolled back.

You can read an explanation of the TransactionOption property here and/or follow thewalkthrough here to see how to implement this.

...

Source: 

cannot connect to database after putting tasks in sequence container

Using Sequence in a Control Flow

Source:How to transaction rollback in ssis?

By using Sequence Containers (Sequence, For Loop, ForEach Loop) in SSIS, you can make use of a property called TransactionOption. This allows you to specify the transactional behaviour of the tasks in your package, and the package itself to rollback if any tasks fail.

For example, if you stick your tasks in a Sequence Container and set TransactionOption=Required, and configure all Tasks within the Container to TransactionOption=Supported, they will all join the transaction started in the Sequence Container, and if any fail, the transaction will be rolled back.

You can read an explanation of the TransactionOption property here and/or follow thewalkthrough here to see how to implement this.

EDIT: Another good walkthrough (with screenshots) here

Removing Duplicates Rows with SSIS Sort Transformation

Environment variable use in package configuration:Good practice or not?

Best Practices for Integration Services Configurations

FAQ - What are the advantages/disadvantages of storing SSIS packages to MSDB vs File System

What tools are out there for profiling stored procedures in SQL server other than the MS profiler?

SQL Server Performance Tuning for Stored Procedures

Tracking Extended Stored Procedures in Profiler

Problem-Solving with SQL Profiler

SQL Server: Using SQL Profiler to Capture Stored Procedure Call from Application

How to Identify Slow Running Queries with SQL Profiler

Stored Procedure ~ Function

Difference between Stored Procedure and Function in SQL Server

Sql Server Database Administration

Sql Server Database Administration

How to remove a column from an existing table?

MS SQL Server Alter Table Drop Column

Removing the IDENTITY Property from an Existing Column

Types of Dimensions

Types of Dimensions