|
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 |  | Author: Jayaram Krishnaswamy
Publisher: Packt Publishing
Category: Book
List Price: $39.99
Buy New: $27.38
as of 9/10/2010 19:55 CDT details
You Save: $12.61 (32%)
New (10) Used (6) from $27.38
Seller: oc_media
Rating:  16 reviews
Sales Rank: 962230
Media: Paperback
Pages: 320
Number Of Items: 1
Shipping Weight (lbs): 1.2
Dimensions (in): 9.2 x 7.5 x 0.8
ISBN: 1847193315
Dewey Decimal Number: 005
EAN: 9781847193315
ASIN: 1847193315
Publication Date: December 30, 2007
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
An ideal book for trainers who may want to teach an introductory course in SQL Server Integration Services or, to those who want to study and learn SSIS in a little over two weeks.
- Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking
- Connect to Microsoft Access, Text Files, Excel Spread Sheets
- Transform data from a source going to a destination
- Use the scripting support that the IDE provides and event handling
- Learn about tasks such as web service and XML, which are new in SQL Server 2005
- Available as an eBook to download immediately
In Detail Sql Server Integration Services (SSIS) is a comprehensive ETL tool that made its debut with SQL Server 2005. It is a tool tightly integrated with the Visual Studio 2005 having all the functionalities that its forerunner DTS (Data Transformation Services) had in SQL Server 2000. This does not mean that it is just an improvement over DTS but a product which is totally different with a vastly improved interface; an extensible architecture; an enlarged tool set; ease of integration with other SQL Server Tools such as Analysis Services; capable of supporting connectivity with third party databases and bringing into a central location many database management tasks. The Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides you with the blocks to build a complete package. It describes each block using examples as well as detailing the nuts and bolts that hold the blocks in place. The majority of SSIS tasks are covered in this book, which are described in full in the summary of Table of Contents. You will start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step. What you will learn from this book? After reading this book you will be able to:
- Understand the Visual Studio 2005's IDE as related to SSIS
- Work with single and multiple tasks; working with more than 20 different tasks.
- Connect to Microsoft Access, Flat Files, Excel Spread Sheets and third party vendor product
- Link data source and data destination to a task
- Send emails and ftp files
- Transform data from a source going to a destination
- Use the scripting support that the IDE provides
- Monitor the data as it is being transported also new in SQL 2005 Server
- Learn tasks such as web service and XML, which are new in SQL Server 2005
- Understand how to use and handle events
Approach Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL (Extraction, Transformation, and Loading). In each chapter you will get a little background of the SSIS task that you are going to create. You will then step through the numbered steps, creating, configuring, executing, and reviewing the results. The book has minimal coding (only two chapters) and exclusively uses the Visual Studio 2005 Designer. Who this book is written for? This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats (jack of all) - developer, programmer, and dba with a little bit of experience in each of these. It is expected that you know how to manipulate window objects, like clicking; dragging and dropping; using contextual help, tabbing, etc. It is also expected that you are exposed to SQL Server database basics and that you understand connecting to a database server; querying the database; reviewing objects; displaying and reviewing properties of objects, etc. Very little coding skill is assumed except that you can logically follow a fully commented code. This book is ideal for trainers who may want to teach an introductory course in SQL Server Integration Services or, to those who want to study and learn SSIS in a little over two weeks.
|
| Customer Reviews:
Showing reviews 1-5 of 16
 Excellent Book for New SSIS Users! September 16, 2008
Anke (Ohio United States)
3 out of 3 found this review helpful
I am new to SQL and SSIS and have been on a mission to master SSIS in SQL 2005. I have purchased about a dozen books, but have yet been able to use most of the books because they are too advanced (even though most say they are for new users).
On my last round of book purchases I picked up Jayaram's "Beginners Guide to SQL...", this is BY FAR the BEST book I have purchased on SSIS! I have actually been able to walk through each one of the examples in the book to gain better understanding of how SQL SSIS works. The books has a lot of excellent screenprints (they do not have figure numbers, but they follow they text and I wasn't confused without the numbers).
The writing style of the book was really straight forward and to the point step-by-step directions, so that you can follow along with a sample database.
Please note in the title of this book it says 'for beginners', so some of the more advanced topics may not be in this book, but it definitely sets you up to have a basic concept and then you can move on. This book allowed me to be able to open the other books I have purchased (and gave me a clue what they were saying).
I would recommend purchasing this book if you are new to SSIS and would like to have a textbook style reference that you can refer back to see how to setup the different SSIS concepts.
-SB
good book to start developing SSIS with Visual Studio 2005 April 5, 2008
Vamseedhar R. Sane (New York, USA)
1 out of 1 found this review helpful
Learning SSIS is one of the most challenging skills for any developer. But this book has made it really easy for any starting developer. This book was specifically written for starting developers as it show the specific steps on how to develop an application from the scratch. Experienced developers will know a trick or two based on the things covered here. The book actually exploits all the possible functions that could be used in SSIS so experienced developers will have the chance to rediscover some of these functions and apply them to their application.
The book is written in learning stages: each part of the SSIS application along with its Visual Studio 2005 counterpart for application development is discussed. These functions are then tested to an actual application. Actual screenshots are used to give the developers an idea on how the application development progresses.
But not everything is presented at once. In the early chapters of the book, developers will first learn the basics on software development using SSIS and Visual Studio 2005. The actual use of the software development tool is presented later.
These basics are enough for the build a simple application. Once the basics are covered an exercise is presented so that developers can immediately apply what they have learned. As the chapters progresses, advanced functions and skills are presented. It is again presented through a series of screen shots so that developers could understand how it is done. Once enough information has been presented, another battery of tests so that skills will be used in the actual scenario.
If you are looking for a good book to start developing SSIS with Visual Studio 2005, this book provides a great start. This book could easily become a good reference book as the skills of the developer progresses in SSIS and Visual Studio.
This book really helped me!!! January 26, 2008
Ruth (Canada)
I needed help getting started on a project using SQL Server and Visual Studio, and this book was an invaluable tool. The author walks you through all the steps, explaining everything. It starts at a basic level and then gets into lots of advanced topics, but the explanation is always bang on. I found it very easy to read and follow, although that was partly that I needed the information immediately.
A Must Book for All SSIS Biginners - Review of Database Administrator SQLAuthority.com January 29, 2008
Pinalkumar Dave (SQLAuthority)
Short Summary:
SQL Server Integration Services Using Visual Studio 2005 contains all the information and education needed for one to begin with SSIS. It covers all the basic concepts in depth and moves towards advance concepts of Extraction, Transformation and Loading (ETL). One book for all the beginners in SSIS.
Detail Summary:
SQL Server Integration Services (SSIS) is a comprehensive ETL tool available in SQL Server 2005. It is integrated with Visual Studio 2005 (VS2K5). SSIS is replacement of Data Transformation Services (DTS) which was used transfer data across SQL Server as well other RDBMS. SSIS contains much more features than previous tool DTS and SSIS integrates with other important tool like Analysis Services.
This book covers comprehensive description of the many designer windows encountered while working with this designer which is quite helpful for all novice SSIS developers. This book provides the building blocks, describing each block by way of an example, as well as describing the nuts and bolts that bind the blocks.
DBA's who are testing water with the Visual Studio IDE but without a wide programming experience will find this book very helpful as well perfect for their need. DBA's may or may not have wide programming experience but they will get going with this book.
Rating: 4 ½ Stars
Summary:
SQL Server Integration Services Using Visual Studio 2005 is step by step, hands on guide will make SSIS beginner appreciate and understand how Business Intelligence (BI) Projects and Packages are created using the Visual Studio designer.
Pinal Dave
Principal Database Administrator
(blog.sqlauthority.com)
Wonderful reference if you need "Hello World" Examples June 2, 2008
Levi Hops (Wisconsin)
This book was worth the money for me. While I am familiar with DTS and SSIS, I've never used them and therefore had no experience for getting started. This book was enough to show me how to create working-though-simple SSIS packages that I can put into production in my work environment. I have yet to find a reference that was easy to read and without speed bumps from one step to the next; this book is the same in that regard. If you need everything spoon-fed to you, you may have problems. The examples are also very simple; they do not go into more advanced details and I can already see I will need more information for certain concepts. But if you need "Hello World" examples to get you going, this is the book you need. But before you do, you will need Visual Studio .NET with Business Intelligence installed an an SQL server that will run SSIS packages.
Showing reviews 1-5 of 16
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
