Acheter neuf

ou
Identifiez-vous pour activer la commande 1-Click.
Acheter d'occasion
D'occasion - Bon Voir les détails
Prix : EUR 5,57

ou
 
   
Plus de choix
Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

 
Dites-le à l'éditeur :
J'aimerais lire ce livre sur Kindle !

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

Professional SQL Server 2000 DTS (Data Transformation Services) [Anglais] [Broché]

Mark Chaffin , Brian Knight , Todd Robinson

Prix : EUR 47,52 Livraison à EUR 0,01 En savoir plus.
  Tous les prix incluent la TVA
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Il ne reste plus que 1 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon. Emballage cadeau disponible.

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Broché EUR 47,52  

Description de l'ouvrage

14 juillet 2000
What is this book about? (DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data–driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. What does this book cover? Here are just a few of the things you′ll find covered in this book: A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packages with VBScript and Visual Basic Writing your own custom tasks Using DTS in a data–warehousing environment Employing DTS in other applications Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.

Offres spéciales et liens associés


Descriptions du produit

Quatrième de couverture

DTS (Data Transformation Services) helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data–driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses. What does this book cover? A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packages with VBScript and Visual Basic Writing your own custom tasks Using DTS in a data–warehousing environment Employing DTS in other applications

Biographie de l'auteur

Mark Chaffin is Data Warehouse Architect for Encore Development (http://www.encoredev.com) and has developed numerous decision support systems for clients in such industries as technology, mortgage banking, retail, sports statistics, financial services, and insurance. He also has experience in clickstream analytics, data mining, transactional application architecture, Internet application architecture, database administration, and database design. Brian Knight (MCSE, MCDBA) is a Senior Database Administrator at Alltel in Jacksonville, Florida, where he manages the mortgage enterprise database system. Brian focuses his developmental time on merging database technologies such as Oracle and DB2 into SQL Server, using DTS and OLAP. He also writes several weekly columns and co–runs the SQL Server area of Swynk.com (a BackOffice–focused Internet site) and writes columns for SQL Magazine. Todd Robinson (MCP, MCP+I, MCP+SB, MCSE, MCSE+I, MCSD, MCDBA, MCT, CCNA) lives in Atlanta, Georgia, where he is an Internet application developer and data–warehousing guru for MetLife. He specializes in COM+, ASP, XML, SQL Server, and related Microsoft .net technologies. In addition to his normal job duties at MetLife, he is President of GradesNow.com, an Internet application service provider for the education community. GradesNow.com allows teachers, students and parents to communicate with one another and show grades online via a web browser. Cary Beuershausen is a Client/Server Programming Consultant in the Internet Solutions group at Alltel (http://www.alltelmd.com) in Jacksonville, Florida. He has developed and implemented document management and workflow solutions in the education, legal, finance, and government sectors. His most recent work has been related to mortgage servicing and Electronic Bill Presentment and he′s looking forward to providing B2B solutions in the mortgage industry with ASP, XML, and just about any other acronym he can find. Cary′s tools of choice are Borland Delphi and Microsoft Visual Basic with a dose of SQL Server thrown in for good measure. In addition to being a full–time programmer, he has also found himself in the classroom teaching VBScript training classes that he developed. He has been pounding out code since his dad brought home a Timex Sinclair ZX–81 many, many years ago and he felt the rush of getting the computer to do what he told it to. Now he gets pumped up trying to figure out how to use the word "polymorphism" in every conversation. Robin Dewson started out on the Sinclair ZX80 (but failing to run a power station, as they claimed), then worked his way through the ZX81 and Spectrum to studying computers at the Scottish College of Textiles, where he was instilled with the belief that mainframes were the future. After many years, he eventually saw the error of his ways and started using Clipper, FoxPro, and Visual Basic. Robin is currently working on a trading system called "Kojak" in a large US investment bank in London, and it was here that he owes a massive debt to Annette Kelly, Daniel Tarbotton, and Andy "I don′t really know, I′ve only been here a week" Sykes for giving him his "big break". Trey Johnson is an international data–warehousing speaker and data–warehousing consultant employed by Encore Development, a provider of web–powered business solutions for Fortune 1000 and mid–market organizations. Trey has been delivering technology solutions with Microsoft SQL Server since version 4.x. Since this start, Trey′s love of data and databases has grown and led him to enterprise multi–terrabyte databases on the Microsoft SQL Server 2000 platform, leveraging the power of technologies like DTS. During the course of his career, Trey has utilized SQL Server and transformation technologies, like DTS, in the delivery of comprehensive Decision Support Solutions for diverse industries such as Health Care, Industrial Warehousing, Financial organizations, Retail, and other service firms.

Détails sur le produit


En savoir plus sur les auteurs

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre (En savoir plus)
Première phrase
DTS - not just another pretty acronym. Lire la première page
En découvrir plus
Concordance
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

Vendre une version numérique de ce livre dans la boutique Kindle.

Si vous êtes un éditeur ou un auteur et que vous disposez des droits numériques sur un livre, vous pouvez vendre la version numérique du livre dans notre boutique Kindle. En savoir plus

Commentaires en ligne 

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 3.6 étoiles sur 5  31 commentaires
27 internautes sur 29 ont trouvé ce commentaire utile 
2.0 étoiles sur 5 Not Enough 10 août 2002
Par Steve Munro - Publié sur Amazon.com
Format:Broché
This book was a disappointment. Mostly it shows how to create packages using the Enterprise Mgr interface. I don't need a book to do that. Right now I am coding a VB app using DTS, and this book was definitely not enough. This is a beginner book, introductory in nature. There is an Object reference, but I can see that in the Object Browser. The examples are simplistic and not real-world. The examples on the SQL Server 2000 Resource Kit are better. I am moving large amounts of data data and have to deal with permissions, constraints, dependency tables -- none of this is covered. You can manipulate the object model thousands of ways; without any guidance on these advanced topics (not covered by MSDN) you are adrift... and your packages will fail every time.
If you are a programmer, don't bother with this one.
15 internautes sur 16 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Not worth it 24 février 2004
Par Steven Nicolaou - Publié sur Amazon.com
Format:Broché|Achat vérifié
You'd think an 880-page tome from Wrox on something as specialised as DTS would pretty much have you covered anytime you need a reliable DTS reference to get you through your Data Transformation tasks. I have found myself looking to this book for guidance on many occasions during development, only to be consistently disappointed. For a start, the Index is downright useless, since I was never able to find words I would expected to, such as delimiter, lineage, disconnected edit, parameterised query, identity insert, but it has an entry for DNS?? (which, btw refers to a 3-line explanation of URLs when using Internet Explorer!) The book is so large mainly because every other page is a GUI snapshot, most of which are unnecessary. I don't need a whole page dedicated to the "Syntax check was successful" message box.
I give it 3 stars because they do a good job of at least mentioning probably every concept that relates to DTS, but coverage is mostly shallow and out of focus. There does seem to be heavy emphasis on data warehousing, which I haven't used so far, so I'll give it the benefit of the doubt regarding coverage there. Overall I still think I might find something good when I need a reference but so far I have mostly found SQL Books Online equally, or sometimes more useful.
12 internautes sur 13 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Very Good 4 septembre 2001
Par Un client - Publié sur Amazon.com
Format:Broché
My company just started using DTS and I needed to learn the technology rapidly. While many Wrox books are 1000+ pages, this book is actually 683. The rest of the pages are devoted to appendixes on the object models.
Another strength of this book is the construction of the chapters. After the introductory 2 chapters, the rest can be read in any order or skipped. This book covered many diverse topics, including data warehouse loading, the DTS object model, VBScript, and even using VB to build new custom tasks.
The book is primarily focused on DBAs. Therefore, there is more coverage of VBScript and COM object development than a programmer would require. However, given the strong chapter cohesiveness, it is easy to skip this material without missing important information.
7 internautes sur 7 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Acceptable, but just barely... 15 janvier 2002
Par Un client - Publié sur Amazon.com
Format:Broché
This is not a very good book on DTS, but, unfortunately, it was the best that I could find. If anyone out there knows of a better book, please let the rest of us know.
The book is not logically organized - probably the result of having several authors. And, I have to agree with the reviewer that stated the index is incomplete. I have on many occasions gone to the index only to find that I have to leaf through the book looking for an item that I saw before but can't remember its exact location. The book is only slightly more helpful that SQL Server's Books Online, but that's only because it's in hard copy. The most useful part of the book to me has been Appendix C, which contains Visual Basic Functions and Keywords.
I wouldn't go so far as to recommend not buying this book, but you should lower your expectations a bit. Frankly, WROX usually does better than this. I hope they are very busily revising this book as I write this review.
Good luck learning DTS, it's not as easy as it might seem at first glance.
11 internautes sur 13 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 The DTS Bible. 24 décembre 2000
Par Un client - Publié sur Amazon.com
Format:Broché
We've purchased three of these after attending a DTS class for our developers and DBAs. It's a little rudamentary in some of the programming concepts but we bought it more for the DTS functionality end. I loved the case study and the error-handling section was extremely helpful.
The book introduces you well to DTS and then proceeds quickly into much more advanced topics. If you don't know programming, the VBScript chapter may be useful. There's a handy reference in the back also to the DTS object model.
Ces commentaires ont-ils été utiles ?   Dites-le-nous

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Thème:
Première publication:
Aller s'identifier
 

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon
   


Rechercher des articles similaires par rubrique


Commentaires

Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?