What is the first article integration Services:ssis?

This article is the first in the Integration Services series, please refer to the original text for more information.

Integration Services is one of the most popular subsystems in SQL Server. Allows you to extract, transform, and load (ETL) data between various data sources, changing data in any programmatic way you can think of.
You can do the following with SSIS:
Perform ETL (extract, transform, load) operations
Transfer data
Copy Database objects
Perform FTP operations
Processing files
"I've never used SSIS before ..."
Are you sure you've never used it before? Do you feel familiar with the following interface?

Figure 1.1 SQL Server Import and Export Wizard
This is from the SQL Server Import and Export Wizard. If you use this wizard, you are using SSIS. One option is the Save SSIS packages check box. By default it is not checked, and most people will easily click on the next step. But if you tick save SSIS package, you can view it later.
How about this interface?

Figure 1.2 Maintenance Planning Tasks
This is the maintenance Plan designer for SSMs. Do you have any guesses? The maintenance plan is also an SSIS package. You can do a lot of things with SSIS, but first learn the short history.
SSIS is just DTS 2.0?
SSIS is not a new version of Data Transformation Services (DTS). It's a replacement for DTS, it's a brand new application--it's newly built, not ported or migrated. This means that upgrading a DTS package to SSIS is more difficult than it looks.
what is SSIS
SSIS is used to perform data integration, assist with database management, and promote business intelligence. Data integration consists primarily of moving data from point A to point B, or from certain sources to certain targets. The source and destination can be either a database or a database. SSIS can connect many data sources and data destinations:
->ole DB
->ado
->ado.net
->excel
->flat File
In addition to built-in connections, SSIS also allows developers to create custom connection managers
Database Management
Sometimes you just need to transfer data. The Import and Export Wizard can migrate data between Excel and SQL Server data tables, flat files, and ODBC connections. It allows data transfer to specify table replication or queries, providing DBAs with the ability to expand or transform data.
A good example is to create or refresh a test database. Production data is often used to verify changes. The SQL Server Import and Export Wizard uses SSIS to move data from the source to the destination.
Business Intelligence
The primary purpose of the business Intelligence (BI) data integration tool is to extract, transform, and load (ETL) operations. SSIS is used to perform ETL. The core of SSIS is the data Flow task, and its design concept is described as "pipeline structure", and the Data Flow task is a powerful and flexible data pump.
SSIS lends itself to design patterns. One popular design pattern for SSIS loads are the Incremental Load, where only new or updated data are moved from the source To the destination table.
In the SSIS data flow, it can be implemented in the following pattern:

Figure 1.3 SSIS Load design pattern
Separation of Duties
Unlike Data Transformation Services (DTS) and other data integration products, SSIS separates workflow and data flow operations. The control flow manages the workflow in a synchronized manner, completing each task sequentially before moving to the next:

Figure 1.4 SSIS Control flow
Concurrency is accomplished by creating multiple execution paths in the control flow. The data stream gets, transforms, and then loads the data "block", one time for a buffer. At any time during a data flow operation, rows may not be read into the data flow pipeline, which is transformed, processed, and loaded into the target by the data flow component:

Figure 1.5 SSIS Data flow
Create a Integration Services project
Click Start, All Programs->microsoft SQL Server R2->SQL server business Intelligence development Studio

Figure 1.6 Opening business Intelligence development Studio
Bids is a version of Microsoft Visual Studio and is Microsoft's integrated development environment (IDE). Many development platforms and languages share the visual Studio IDE. For example, Microsoft Visual C # and Microsoft Visual Basic are included.
Once you open bids, create an SSIS project with the new project, file-
When the New Project dialog box opens, in the upper-left corner of the project type, select Business Intelligence Project. As mentioned earlier, Vs/bids supports multiple languages and development platforms. The project type contains a list of languages and platforms that have already been installed. If you have other platforms and languages installed, they will be added to this list.
Once you select a project type, the available project type templates appear in the template list. Select "Integration Services Project"
In the lower section of the New Project dialog box, type "My_first_ssis_project" for the name. You can accept the default file location, or click Browse to select another path to hold the SSIS project.

Figure 1.7 New Project
When you type the project name, the solution name duplicates the project name. You can modify the solution name to a different name. Once you type the solution name, the "link" between the project name and the solution name is cut off.
The Create directory for Solution check box, add a folder on the project folder that contains Visual Studio artifacts related to the Visual Studio solution, the solution file that contains information about the project in the solution.
If you have a source control (or version control) client installed and configured, you can choose to add the solution to source control when you create it by selecting the "Add to Source Controls" check box.
When you click OK, the solution containing the My_first_ssis_project project will be created.
Summary
In this article we introduce SSIS and outline its architecture. In a later article, we'll delve into SSIS.

What is the first article integration Services:ssis?