Professional SQL Server 2000 DTS (Data Transformation Service)
Professional SQL Server 2000 DTS (Data Transformation Service)
Overview
A lot of corporate databases are what's behind the Internet revolution.Professional SQL Server 2000 DTSgives DBAs and programmers a handy guide to getting the most out of the Data Transformation Services (DTS)--a flexible set of tools that work on a wide variety of databases--that are available in SQL Server 2000.The hands-on focus of the book makes it a win for readers of all backgrounds. While online help for DTS is not always easy to decipher, this book remedies the situation with plenty of screen shots of all of the major tools in action. Early sections examine nearly two dozen built-in tasks or functions in DTS--from the obvious (copying data from one database to another) to the more esoteric (sending files via FTP within DTS).A gentle introduction to using VBScript and ActiveX objects gets at the DTS object model to design "custom tasks." By using this approach, you can automate and transform data reliably among different formats, including mainframe and Office documents. (Specific tips guide you in working with DB2 and Excel data.) A standout section looks at "linking" servers and querying data from heterogeneous sources.You also learn how to build a Web front end (using ASPs) for a data application that uses SQL-DMO APIs to automate database tasks through a browser. Later, there's an excellent tutorial on data warehousing, done the Microsoft way--from the basics of the star, snowflake, and hybrid fact tables for a data mart to setting up and loading the data using DTS, and then running the database with Microsoft Analysis Services. The book closes with a thorough reference section that lists the objects and methods in the DTS object model.Whether you're performing normal database administration or setting up a data warehouse--or you just want to work with data more effectively within your applications--Professional SQL Server 2000 DTSgives you all of the information that you need to be productive with a powerful (and sometimes overlooked) set of database tools and components.--Richard DraganTopics covered:Introduction to Data Transformation Services (DTS)Survey of DTS wizards and toolsThe Import/Export WizardThe Copy Database WizardThe DTS DesignerSurvey of automated tasks in SQL Server 2000, including the Bulk Insert, Execute SQL, Copy SQL Server Objects, and Transfer Databases tasksThe Multiphase Data PumpUsing a Data Driven Query (DDQ)The FTP TaskThe Execute Package TaskThe Message Queue TaskAdvanced package optionsGeneral package propertiesTransfer Data Task optionsData scrubbingWorking with heterogeneous data (using linked servers from mainframe and legacy servers)Tips for converting Excel and DB2 dataDTS ActiveX Script basicsQuick tutorial for VBScript syntaxThe DTS Object ModelFile management with theFileSystemObjectobjectDTS security issuesMeta Data ServicesBacking up databasesDTS error handlingBuilding custom tasks in DTSStar, snowflake, and hybrid designs for data warehousesExtract, Transformation, and Load (ETL) with DTSMicrosoft Analysis ServicesCreating Web front ends for DTS applicationsReference to the DTS and ADO object modelsReference to essential VB functions and keywordsMicrosoft Scripting Run-Time ReferenceDescription
Condition Guidelines
Books - New and Used
The following guidelines apply to books:
- New: A brand-new copy with cover and original protective wrapping intact. Books with markings of any kind on the cover or pages, books marked as "Bargain" or "Remainder," or with any other labels attached, may not be listed as New condition.
- Used - Good: All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels. Shrink wrap, dust covers, or boxed set case may be missing. Item may be missing bundled media.
- Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may but the dust cover may be missing. Pages may include limited notes and highlighting, but the text cannot be obscured or unreadable.
Note: Some electronic material access codes are valid only for one user. For this reason, used books, including books listed in the Used – Like New condition, may not come with functional electronic material access codes.
Shipping & Delivery
Shipping Fees
- Stevens Books offers FREE SHIPPING everywhere in the United States for ALL non-book orders, and $3.99 for each book.
- Packages are shipped from Monday to Friday.
- No additional fees and charges.
Delivery Times
The usual time for processing an order is 24 hours (1 business day), but may vary depending on the availability of products ordered. This period excludes delivery times, which depend on your geographic location.
Estimated delivery times:
- Standard Shipping: 5-8 business days
- Expedited Shipping: 3-5 business days
Shipping method varies depending on what is being shipped.
Tracking
All orders are shipped with a tracking number. Once your order has left our warehouse, a confirmation e-mail with a tracking number will be sent to you. You will be able to track your package at all times.
Damaged Parcel
If your package has been delivered in a PO Box, please note that we are not responsible for any damage that may result (consequences of extreme temperatures, theft, etc.).
If you have any questions regarding shipping or want to know about the status of an order, please contact us or email to support@stevensbooks.com.
Returns & Refunds
You may return most items within 30 days of delivery for a full refund.
To be eligible for a return, your item must be unused and in the same condition that you received it. It must also be in the original packaging.
Several types of goods are exempt from being returned. Perishable goods such as food, flowers, newspapers or magazines cannot be returned. We also do not accept products that are intimate or sanitary goods, hazardous materials, or flammable liquids or gases.
Additional non-returnable items:
- Gift cards
- Downloadable software products
- Some health and personal care items
To complete your return, we require a tracking number, which shows the items which you already returned to us.
There are certain situations where only partial refunds are granted (if applicable)
- Book with obvious signs of use
- CD, DVD, VHS tape, software, video game, cassette tape, or vinyl record that has been opened
- Any item not in its original condition, is damaged or missing parts for reasons not due to our error
- Any item that is returned more than 30 days after delivery
Items returned to us as a result of our error will receive a full refund,some returns may be subject to a restocking fee of 7% of the total item price, please contact a customer care team member to see if your return is subject. Returns that arrived on time and were as described are subject to a restocking fee.
Items returned to us that were not the result of our error, including items returned to us due to an invalid or incomplete address, will be refunded the original item price less our standard restocking fees.
If the item is returned to us for any of the following reasons, a 15% restocking fee will be applied to your refund total and you will be asked to pay for return shipping:
- Item(s) no longer needed or wanted.
- Item(s) returned to us due to an invalid or incomplete address.
- Item(s) returned to us that were not a result of our error.
You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).
If you need to return an item, please Contact Us with your order number and details about the product you would like to return. We will respond quickly with instructions for how to return items from your order.
Shipping Cost
We'll pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.). In other cases, you will be responsible for paying for your own shipping costs for returning your item. Shipping costs are non-refundable. If you receive a refund, the cost of return shipping will be deducted from your refund.
Depending on where you live, the time it may take for your exchanged product to reach you, may vary.
If you are shipping an item over $75, you should consider using a trackable shipping service or purchasing shipping insurance. We don’t guarantee that we will receive your returned item.
Overview
A lot of corporate databases are what's behind the Internet revolution.Professional SQL Server 2000 DTSgives DBAs and programmers a handy guide to getting the most out of the Data Transformation Services (DTS)--a flexible set of tools that work on a wide variety of databases--that are available in SQL Server 2000.The hands-on focus of the book makes it a win for readers of all backgrounds. While online help for DTS is not always easy to decipher, this book remedies the situation with plenty of screen shots of all of the major tools in action. Early sections examine nearly two dozen built-in tasks or functions in DTS--from the obvious (copying data from one database to another) to the more esoteric (sending files via FTP within DTS).A gentle introduction to using VBScript and ActiveX objects gets at the DTS object model to design "custom tasks." By using this approach, you can automate and transform data reliably among different formats, including mainframe and Office documents. (Specific tips guide you in working with DB2 and Excel data.) A standout section looks at "linking" servers and querying data from heterogeneous sources.You also learn how to build a Web front end (using ASPs) for a data application that uses SQL-DMO APIs to automate database tasks through a browser. Later, there's an excellent tutorial on data warehousing, done the Microsoft way--from the basics of the star, snowflake, and hybrid fact tables for a data mart to setting up and loading the data using DTS, and then running the database with Microsoft Analysis Services. The book closes with a thorough reference section that lists the objects and methods in the DTS object model.Whether you're performing normal database administration or setting up a data warehouse--or you just want to work with data more effectively within your applications--Professional SQL Server 2000 DTSgives you all of the information that you need to be productive with a powerful (and sometimes overlooked) set of database tools and components.--Richard DraganTopics covered:Introduction to Data Transformation Services (DTS)Survey of DTS wizards and toolsThe Import/Export WizardThe Copy Database WizardThe DTS DesignerSurvey of automated tasks in SQL Server 2000, including the Bulk Insert, Execute SQL, Copy SQL Server Objects, and Transfer Databases tasksThe Multiphase Data PumpUsing a Data Driven Query (DDQ)The FTP TaskThe Execute Package TaskThe Message Queue TaskAdvanced package optionsGeneral package propertiesTransfer Data Task optionsData scrubbingWorking with heterogeneous data (using linked servers from mainframe and legacy servers)Tips for converting Excel and DB2 dataDTS ActiveX Script basicsQuick tutorial for VBScript syntaxThe DTS Object ModelFile management with theFileSystemObjectobjectDTS security issuesMeta Data ServicesBacking up databasesDTS error handlingBuilding custom tasks in DTSStar, snowflake, and hybrid designs for data warehousesExtract, Transformation, and Load (ETL) with DTSMicrosoft Analysis ServicesCreating Web front ends for DTS applicationsReference to the DTS and ADO object modelsReference to essential VB functions and keywordsMicrosoft Scripting Run-Time ReferenceDescription
Condition Guidelines
Books - New and Used
The following guidelines apply to books:
- New: A brand-new copy with cover and original protective wrapping intact. Books with markings of any kind on the cover or pages, books marked as "Bargain" or "Remainder," or with any other labels attached, may not be listed as New condition.
- Used - Good: All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels. Shrink wrap, dust covers, or boxed set case may be missing. Item may be missing bundled media.
- Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may but the dust cover may be missing. Pages may include limited notes and highlighting, but the text cannot be obscured or unreadable.
Note: Some electronic material access codes are valid only for one user. For this reason, used books, including books listed in the Used – Like New condition, may not come with functional electronic material access codes.
Shipping & Delivery
Shipping Fees
- Stevens Books offers FREE SHIPPING everywhere in the United States for ALL non-book orders, and $3.99 for each book.
- Packages are shipped from Monday to Friday.
- No additional fees and charges.
Delivery Times
The usual time for processing an order is 24 hours (1 business day), but may vary depending on the availability of products ordered. This period excludes delivery times, which depend on your geographic location.
Estimated delivery times:
- Standard Shipping: 5-8 business days
- Expedited Shipping: 3-5 business days
Shipping method varies depending on what is being shipped.
Tracking
All orders are shipped with a tracking number. Once your order has left our warehouse, a confirmation e-mail with a tracking number will be sent to you. You will be able to track your package at all times.
Damaged Parcel
If your package has been delivered in a PO Box, please note that we are not responsible for any damage that may result (consequences of extreme temperatures, theft, etc.).
If you have any questions regarding shipping or want to know about the status of an order, please contact us or email to support@stevensbooks.com.
Returns & Refunds
You may return most items within 30 days of delivery for a full refund.
To be eligible for a return, your item must be unused and in the same condition that you received it. It must also be in the original packaging.
Several types of goods are exempt from being returned. Perishable goods such as food, flowers, newspapers or magazines cannot be returned. We also do not accept products that are intimate or sanitary goods, hazardous materials, or flammable liquids or gases.
Additional non-returnable items:
- Gift cards
- Downloadable software products
- Some health and personal care items
To complete your return, we require a tracking number, which shows the items which you already returned to us.
There are certain situations where only partial refunds are granted (if applicable)
- Book with obvious signs of use
- CD, DVD, VHS tape, software, video game, cassette tape, or vinyl record that has been opened
- Any item not in its original condition, is damaged or missing parts for reasons not due to our error
- Any item that is returned more than 30 days after delivery
Items returned to us as a result of our error will receive a full refund,some returns may be subject to a restocking fee of 7% of the total item price, please contact a customer care team member to see if your return is subject. Returns that arrived on time and were as described are subject to a restocking fee.
Items returned to us that were not the result of our error, including items returned to us due to an invalid or incomplete address, will be refunded the original item price less our standard restocking fees.
If the item is returned to us for any of the following reasons, a 15% restocking fee will be applied to your refund total and you will be asked to pay for return shipping:
- Item(s) no longer needed or wanted.
- Item(s) returned to us due to an invalid or incomplete address.
- Item(s) returned to us that were not a result of our error.
You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).
If you need to return an item, please Contact Us with your order number and details about the product you would like to return. We will respond quickly with instructions for how to return items from your order.
Shipping Cost
We'll pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.). In other cases, you will be responsible for paying for your own shipping costs for returning your item. Shipping costs are non-refundable. If you receive a refund, the cost of return shipping will be deducted from your refund.
Depending on where you live, the time it may take for your exchanged product to reach you, may vary.
If you are shipping an item over $75, you should consider using a trackable shipping service or purchasing shipping insurance. We don’t guarantee that we will receive your returned item.
Oops!
Sorry, it looks like some products are not available in selected quantity.
