Introduction to SSIS

One, what is SSIS

1.SSIS is the abbreviation for Microsoft SQL Server Integration Services and is a platform for generating high-performance data integration solutions, including extraction, transformation, and loading (ETL) packages for data warehouses.

The above text from Baidu, out of this concept, I have been thinking about how to explain to the common people SSIS system: I think I have to explain it is very likely not in place, so deliberately to know the inside asked the question:

How to interpret SSIS

Seemingly without very good effect, I understand that SSIS is like this:

A strong muscle man, able to carry a lot of cargo (data), can do what most people can do (especially 2008 after adding a Script task, you can run. NET 3.5 function), the most important thing is that he is a Porter (service object is data). The efficiency and the function are strong, the error handling is quite excellent.

Two, why (why?)

Why study SSIS, and what is the benefit of this study, in my opinion, a system that you learn in a short period of time can produce very little direct economic benefits, because when I look at 51job search for SSIS, I find that it takes at least 3-5 years of work experience, or you must have a DW The experience of [data Wirehouse] is obviously a bit out of the way after spending the same time learning such things, but I would like to cite an example in the opposite way:

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/

1. This could be your chance to make a qualitative leap, from a pure code farmer to a BI practitioner, SSIS may give you a quick interest in the industry and invest in it.

2.BI is not the average C # code farmer can reach (^_^ Yes, that's one of the reasons I put it into bi.)

Third, how to learn (how?)

First you have to have such an environment, including

1.sql Server Business Intelligence Development Studio (version 2008) (selected at the time of SQL Server 2008 installed)

2.sqlserver 2008 R2

Second, you have to have a xianxin, because frozen three overnight cold, in this tutorial series I intend to share a set of business-value SSIS architecture (if you can stick to the back), then have a certain English foundation, because I find that the better SSIS tutorials are from abroad, if you always "I do not have that xianxin and English to deal with" the mentality, although you can very fast study, but the future further improvement I cannot assert.

Problem:

1. Why do you write this series?

A: Because I did a project, I found that Bi's front (salary) is not (very) wrong (high), so I intend to do my own project when the raid SSIS once again, of course, also want to better communicate with you

2. What are the benefits of looking at this series of posts?

A: This blog is divided into three series, learning, combat, application, to the third link, I intend to come up with me in the company to learn the SSIS framework to share with you, we learn

3. How to learn more quickly?

A: I read a word on the CSDN, the book is not as good as the hands of a row, beating the hands of thousands of lines than Tan Bu line, reading, learning, practice, record, summary, reflection so as if, this effect is best, even if the practice of "sunflower book" also needs a cut JJ process, so there is no so-called fast.

4. Is the blogger busy?

A: So far, this bi project just finished, just have time to sum up the things before learning.