and over one million other books are available for Amazon Kindle. Learn more
Buy New
$37.99
Qty:1
  • List Price: $39.99
  • Save: $2.00 (5%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 Paperback – December 30, 2007

ISBN-13: 978-1847193315 ISBN-10: 1847193315

Buy New
Price: $37.99
18 New from $37.99 15 Used from $25.40
Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$37.99
$37.99 $25.40

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Customers Who Viewed This Item Also Viewed

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 80%). Print edition purchase must be sold by Amazon. Learn more.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 320 pages
  • Publisher: Packt Publishing (December 30, 2007)
  • Language: English
  • ISBN-10: 1847193315
  • ISBN-13: 978-1847193315
  • Product Dimensions: 0.7 x 7.4 x 9.1 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #2,331,377 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Jayaram Krishnaswamy studied at the Indian Institute of Science in Bangalore India and Madras University in India and taught at the Indian Institute of Technology in Madras. He went to Japan on a Japanese Ministry of Education Research scholarship to complete his PhD in Electrical Engineering from Nagoya University. He was a Post Doctoral Fellow at Sydney University in Australia; a Government of India Senior Scientific Officer at the Indian Institute of Science in Bangalore and Indian Institute of Technology at Kanpur; a Visiting Scientist at the Eindhoven Institute of Technology in Netherlands; a Visiting Professor of Physics at the Federal University in Brazil; an Associate Research Scientist at a government laboratory in Sao Jose dos Campos in Sao Paulo, Brazil; a visiting scientist at the National Research Council in Ottawa, Canada before coming to USA in 1985. He has also taught and worked at the Colorado State University in Fort Collins and North Carolina State University in Raleigh, North Carolina. He worked with Northrop Grumman Corporation on a number of projects related to high energy electron accelerators / Free Electron Lasers. These projects were undertaken at the Brookhaven National Laboratory in Long Island and in the Physics Department at Princeton University. He has over 80 publications in refereed and non-refereed publications and 8 issued patents. He is fluent in Japanese and Portuguese and lives in Plainsboro, New Jersey, USA. He has been working in the IT related fields since 1997. He was once a Microsoft Certified Trainer in Networking and a Siebel developer. He has worked with several IT related companies, such as the Butler International in their Siebel practice; several other IBM sub contractors and smaller companies. Presently he is active in writing technical articles in the IT field to many online sites such as CodeProject, APSFree.com, DevShed.com, DevArticles.com, OfficeUsers.org, ASPAlliance.com, ITToolbox.com, databasedev.co.uk, cimaware.com, and many others. During 2006-2007 he wrote more than 200 articles mostly related to database and web related technologies covering Microsoft, Oracle, Sybase, ColdFusion, Sun and other vendor products.

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.5 out of 5 stars
5 star
7
4 star
5
3 star
0
2 star
0
1 star
5
See all 17 customer reviews
I also found that it contained many technical inaccuracies.
Tod McKenna
If you have a DTS background you'll love this book, if you have no DTS background it's even better... The book is very detailed well written.
Cool_Sam
If you are a SQL DBA or have a little experience with DTS; this is book you need.
S. Rahman

Most Helpful Customer Reviews

19 of 20 people found the following review helpful By Tod McKenna on February 23, 2008
Format: Paperback
SSIS is a very good data integration tool. It is easy to get started with, but takes some time and experience to master. Although I have some heavy beefs about the 2005 version (metadata management, validation issues, proprietary expression builder, no C# for the Script Task, etc...), all-in-all, I do find SSIS to be good to work with.

I was excited to get this book in the mail, as I know how difficult it is to find a good beginners guide for SSIS. I'm no longer a newbie, but I once was and I found that the good books were almost too advanced and too comprehensive to get some simple tasks done and to get a good understanding of the tool and involved concepts.

Unfortunately, I found this book difficult to read. I also found that it contained many technical inaccuracies. The author (a non-native English speaker I assume) struggles to get good, succinct points across. I am not saying that a total beginner could not get into this book and get a few packages developed, but for Data Warehousing professionals, DBAs, and developers, this is not the book to keep in your reference library.

For example, on page 123, the author writes:

"The Bulk Insert Task cannot be used with any of the data flow transformation components, and in this respect is not as versatile as a data flow task. This task has been provided for backward compatibility."

Hmmn... First of all, it would be nice to know why the Bulk Insert Task cannot be used with any of the transforms (short answer: The Bulk Insert Task is a Control Flow item). It would also be very helpful to the reader to have an idea why you would select a Bulk Insert over a Data Flow. Lastly, the Bulk Insert Task is *not* provided for backward compatibility!
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Richard J. Dudley on June 7, 2008
Format: Paperback
If you can create an SSIS package, and understand most of what the different toolbox object are, this is not the book for you. If you don't even know ho to create an SSIS package, and need to do so quickly, buy this book. In a couple hours, you'll be proficient in the basics of SSIS.

Packt asked me to review this book, and their timing was perfect--I was ready to start an SSIS project but had no experience. I was a heavy DTS user, and the difference between DTS and SSIS blew my mind. The first two chapters are a reference of the different flows, transformations, sources and destinations available, and the rest of the book is essentially a workbook, full of how-to examples for very common tasks. Even if what you need to do isn't covered,

I did hope there would be a section on the new "fuzzy" objects, but there was none. This book also does not discuss way to organize your solutions and projects, but this also was left to more advanced books.

I've loaned this book to several coworkers, and all have found it useful. We all came up to a basic understanding of SSIS very quickly, and have a good enough understanding to pick up more advanced examples.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Anke on September 16, 2008
Format: Paperback
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Cool_Sam on April 16, 2010
Format: Paperback Verified Purchase
I come from DTS (SQL server 2000) got very frustrated with SSIS. DTS packages I use to write "with my eyes closed" became nightmare adventures in SSIS I purchased a $300 online video course. It didn't help much. When I got this book the whole game changed. This is a great book. If you have a DTS background you'll love this book, if you have no DTS background it's even better... The book is very detailed well written. I highly recommend it. I hope Jayaram will be writing an intermediate and advanced book on this topic.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Vamseedhar R. Sane on April 5, 2008
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search