|
![]() |
|||
|
||||
OverviewIdeal for classes on SQL Server that's intended to teaching students more than the basic. Full Product DetailsAuthor: Jim Samuelson , M. Santos , S. Miller , S. HughesPublisher: Pearson Education (US) Imprint: New Riders Publishing Dimensions: Width: 22.80cm , Height: 2.50cm , Length: 17.90cm Weight: 0.780kg ISBN: 9780735711235ISBN 10: 0735711232 Pages: 512 Publication Date: 04 September 2001 Audience: College/higher education , Tertiary & Higher Education Format: Paperback Publisher's Status: Out of Print Availability: Out of stock ![]() Table of ContentsPLEASE PROVIDE I. DATA TRANSFORMATION SERVICES—THE TOOL. 1. Introduction to Extraction, Transformation and Loading (ETL) Environment. 2. Introduction to Data Transformations Services. 3. DTS Package and Components. II. AUTOMATING DATA TRANSFORMATION SERVICES. 4. Building a Package from a Visual Basic Application. 5. Interacting with a Package from a Visual Basic Application. III. USING THE TOOL—PUTTING IT ALL TOGETHER. 6. Error Logging. 7. Interacting with ActiveX components. 8. Managing Distributed Databases with DTS and MSMQ. 9. Replication and DTS. 10. Packages that control other packages. 11. Custom Tasks. 12. Building and Managing a Data Warehouse with DTS. 13. DTS and Data Mining. 14. Executing a DTS Package from a Stored Procedure.ReviewsAuthor InformationJim Samuelson is the Enterprise Data Services Practice Lead for Magenic Technologies in Minneapolis. Jim has over 11 years of experience in Decision Support and Business Intelligence Systems, and currently serves on the Microsoft Business Intelligence Partner Advisory Council. Jim speaks at local, regional and national events on various database and software development topics. He holds an MBA in Finance and M.I.S, and is a Microsoft Certified Solution Developer (MCSD). Marcelino Santos, MCSE, MCSD, is a Senior Consultant at Magnenic Technologies. He has over 16 years of experience as a business analys and software developer within the areas of enterprise modeling, strategic business and information systems planning, data and functional modeling, decision tools, business solutions, and systems integration. Tab Content 6Author Website:Countries AvailableAll regions |