Pro SQL Server 2005 Integration Services
After much muttering and stroking of beards, the idea of taking data and pushing it through various transformations and processing pipelines was born. Suddenly the data could explain forensically where fraud was taking place, show where and when to invest to increase profits, and describe trends...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2012
|
| Những chủ đề: | |
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31634 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-31634 |
|---|---|
| record_format |
dspace |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-316342014-01-20T05:59:48Z Pro SQL Server 2005 Integration Services Wightman, James Technologies After much muttering and stroking of beards, the idea of taking data and pushing it through various transformations and processing pipelines was born. Suddenly the data could explain forensically where fraud was taking place, show where and when to invest to increase profits, and describe trends across the most demanding of datasets. SQL Server Integration Services is a tool that can do this with your data, and more. It is the Rosetta Stone for having your data make sense and provide business insight and value. It isn’t the only tool on the mar- ket that performs these tasks, but, based purely on my experiences using it and most of its competitors, I feel it is the best around. ■ CHAPTER 1 Introducing SQL Server 2005 Integration Services . . . . . . . . . . . . . . . 1 ■ CHAPTER 2 The Architecture of SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 ■ CHAPTER 3 From DTS to SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 ■ CHAPTER 4 The IDE and Extending Visual Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 ■ CHAPTER 5 Package Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 ■ CHAPTER 6 Control Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 ■ CHAPTER 7 Maintenance Plans . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 ■ CHAPTER 8 Data Flow Data Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 ■ CHAPTER 9 Basic Data Flow Transformations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199 ■ CHAPTER 10 Advanced Data Flow Transformations . . . . . . . . . . . . . . . . . . . . . . . . . 241 ■ CHAPTER 11 Data Flow Destinations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 ■ CHAPTER 12 Optimization for SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 ■ CHAPTER 13 SSIS Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337 ■ CHAPTER 14 Scripting, .NET Style . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 ■ CHAPTER 15 Custom Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 ■ APPENDIX A Interview with Donald Farmer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 ■ APPENDIX B The Package Object . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 ■ APPENDIX C The Control Flow Object . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 477 ■ APPENDIX D Maintenance Plans Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 509 ■ APPENDIX E Data Flow Object Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 519 ■ INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 523 2012-08-30T03:05:48Z 2012-08-30T03:05:48Z 2008 Book 978-1-59059-897-9 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31634 en application/pdf Apress |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
Technologies |
| spellingShingle |
Technologies Wightman, James Pro SQL Server 2005 Integration Services |
| description |
After much muttering and stroking of beards, the idea of taking data and pushing it
through various transformations and processing pipelines was born. Suddenly the data could
explain forensically where fraud was taking place, show where and when to invest to increase
profits, and describe trends across the most demanding of datasets. SQL Server Integration
Services is a tool that can do this with your data, and more. It is the Rosetta Stone for having
your data make sense and provide business insight and value. It isn’t the only tool on the mar-
ket that performs these tasks, but, based purely on my experiences using it and most of its
competitors, I feel it is the best around. |
| format |
Book |
| author |
Wightman, James |
| author_facet |
Wightman, James |
| author_sort |
Wightman, James |
| title |
Pro SQL Server 2005 Integration Services |
| title_short |
Pro SQL Server 2005 Integration Services |
| title_full |
Pro SQL Server 2005 Integration Services |
| title_fullStr |
Pro SQL Server 2005 Integration Services |
| title_full_unstemmed |
Pro SQL Server 2005 Integration Services |
| title_sort |
pro sql server 2005 integration services |
| publisher |
Apress |
| publishDate |
2012 |
| url |
http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31634 |
| _version_ |
1757676956195749888 |