SSIS Tutorials

it's the solution for automating SQL Server.
SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way.

Creating a Package using BIDS

• Connections to data sources.
• Data flows, which include the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations.
• Control flows, which include tasks and containers that execute when the package runs. You can organize tasks in sequences and in loops.
• Event handlers, which are workflows that runs in response to the events raised by a package, task, or container.

SSIS uses connection managers to integrate different data sources into packages.

connection manager depends on what type of data sources we are dealing with.
for connecting ADO record set we have to use ADO connection manager
ADO.NET data source we have to use ADO.NET connection manager.

The Control Flow tab of the Package Designer is where you tell SSIS what the package will do.

Ref: http://www.accelebrate.com/sql_training/ssis_tutorial.htm