SSIS Learning Journey Prologue and introduction

SSIS Learning Tour Directory:

Chapter One: SSIS Learning Journey First example of SSIS (i)

Chapter Two: SSIS Learning Journey The first SSIS example (ii)

Chapter III: SSIS Learning Journey Data Synchronization

Fourth: SSIS Learning Journey FTP File Transfer-ftp task

Fifth: SSIS Learning Journey FTP File Transfer-Script task

Sixth: SSIS Learning Journey FTP Access Class

SSIS is the abbreviation for Microsoft SQL Server Integration Services.
is to build a high-performance data integration solution that is a great tool for Microsoft BI Solutions.

Integration Services includes graphical tools and wizards for building and debugging packages;
A task that performs a workflow function (such as an FTP operation), executes a SQL statement, or sends an e-mail message;
Data sources and targets for extracting and loading data;
Transformations for cleaning, aggregating, merging, and replicating data;
Management Services Integration Services for managing Integration services;
and the Application Programming Interface (API) used to program the integration Services object model.

The architecture of SSIS consists of four main parts: theIntegration Services service, the Integration Services object model,
integration Services Runtime and runtime executables and data flow tasks that encapsulate the data flow engine and data flow components ()：

This is what we beginners must understand, as long as we understand the structure of the individual system, and experience the relationship between the components,
Knowing what the control flow is and what the data flow is, SSIS is easy to learn.

Let's take a look at the use of SSIS from an example. Of course you want to execute the example successfully. You need to install SQL Server2012,
Select the Install Integration Services and Business Intelligence Development Studio option. This way the SSIS development platform will be installed together.

1. Click Start, All Programs-〉sql Server 2008-〉SQL server business Intelligence development Studio.
The first time you open the development environment, you may have to wait a few minutes. The development tool is similar to the VS development tool

2. After opening bids, we can click File-> to create a new-〉 project. ():

3. In the Templates pane of the New Project dialog box, select Integration Services Project.
Then, in the Name box, modify the default name to the name that you want. This design is as follows. ():

4. Click the "OK" button. By default, an empty package named Package.dtsx is created.

5. After creating the good one SSIS project, we can control the flow in the PACKAGE.DTSX package,
The Data Flow tab in the hold control to design the SSIS package. Location of the Toolbox for SSIS ():

The development tools of this series are all business Intelligence development Studio 2010 Versions
As a result of work changes, so write some small examples for everyone to refer to the study. Some of the wrong places also invite everyone to include.

SSIS Learning Journey Prologue and introduction