Picture 1 of 1
Picture 1 of 1
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer [With...
by Knight, Brian; Knight, Devin;... | PB | Acceptable
US $6.31
Condition:
“Missing dust jacket; Readable copy. Pages may have considerable notes/highlighting. ~ ”... Read moreabout condition
Shipping:
Estimated between Sat, Jun 15 and Tue, Jun 18 to 43230
Located in: Aurora, Illinois, United States
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:145377362222
Item specifics
- Condition
- Acceptable
- Seller Notes
- Binding
- Paperback
- Weight
- 1 lbs
- Product Group
- Book
- IsTextBook
- No
- ISBN
- 9781118479582
- Subject Area
- Computers
- Publication Name
- Knight's Microsoft Sql Server 2012 Integration Services 24 h Trainer
- Item Length
- 9.2 in
- Publisher
- Wiley & Sons, Incorporated, John
- Subject
- Databases / Data Warehousing, Databases / General
- Publication Year
- 2012
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1 in
- Item Width
- 7.4 in
- Item Weight
- 32.6 Oz
- Number of Pages
- 528 Pages
About this product
Product Information
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012 If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution.
Product Identifiers
Publisher
Wiley & Sons, Incorporated, John
ISBN-10
1118479580
ISBN-13
9781118479582
eBay Product ID (ePID)
117222827
Product Key Features
Publication Name
Knight's Microsoft Sql Server 2012 Integration Services 24 h Trainer
Format
Trade Paperback
Language
English
Subject
Databases / Data Warehousing, Databases / General
Publication Year
2012
Type
Textbook
Subject Area
Computers
Number of Pages
528 Pages
Dimensions
Item Length
9.2 in
Item Height
1 in
Item Width
7.4 in
Item Weight
32.6 Oz
Additional Product Features
LCCN
2012-948658
Intended Audience
Trade
Number of Volumes
1 Vol.
Lc Classification Number
Qa76.9.D3
Table of Content
PREFACE xxv WELCOME TO SSIS 1 SECTION 1: INSTALLATION AND GETTING STARTED LESSON 1: MOVING DATA WITH THE IMPORT AND EXPORT WIZARD 11 LESSON 2: INSTALLING SQL SERVER INTEGRATION SERVICES 17 LESSON 3: INSTALLING THE SAMPLE DATABASES 21 LESSON 4: CREATING A SOLUTION AND PROJECT 25 LESSON 5: EXPLORING SQL SERVER DATA TOOLS 29 LESSON 6: CREATING YOUR FIRST PACKAGE 35 LESSON 7: UPGRADING PACKAGES TO SQL SERVER 2012 41 LESSON 8: UPGRADING TO THE PROJECT DEPLOYMENT MODEL 47 SECTION 2: CONTROL FLOW LESSON 9: USING PRECEDENCE CONSTRAINTS 59 LESSON 10: MANIPULATING FILES WITH THE FILE SYSTEM TASK 63 LESSON 11: CODING CUSTOM SCRIPT TASKS 71 LESSON 12: USING THE EXECUTE SQL TASK 79 LESSON 13: USING THE EXECUTE PROCESS TASK 87 LESSON 14: USING THE EXPRESSION TASK 93 LESSON 15: USING THE SEND MAIL TASK 99 LESSON 16: USING THE FTP TASK 107 LESSON 17: CREATING A DATA FLOW 113 SECTION 3: DATA FLOW LESSON 18: EXTRACTING DATA FROM SOURCES 121 LESSON 19: LOADING DATA TO A DESTINATION 139 LESSON 20: CHANGING DATA TYPES WITH THE DATA CONVERSION TRANSFORM 151 LESSON 21: CREATING AND REPLACING COLUMNS WITH THE DERIVED COLUMN TRANSFORM 159 LESSON 22: ROLLING UP DATA WITH THE AGGREGATE TRANSFORM 167 LESSON 23: ORDERING DATA WITH THE SORT TRANSFORM 173 LESSON 24: JOINING DATA WITH THE LOOKUP TRANSFORM 179 LESSON 25: AUDITING DATA WITH THE ROW COUNT TRANSFORM 189 LESSON 26: COMBINING MULTIPLE INPUTS WITH THE UNION ALL TRANSFORM 193 LESSON 27: CLEANSING DATA WITH THE SCRIPT COMPONENT 197 LESSON 28: SEPARATING DATA WITH THE CONDITIONAL SPLIT TRANSFORM 203 LESSON 29: ALTERING ROWS WITH THE OLE DB COMMAND TRANSFORM 211 LESSON 30: HANDLING BAD DATA WITH THE FUZZY LOOKUP 221 LESSON 31: REMOVING DUPLICATES WITH THE FUZZY GROUPING TRANSFORM 231 SECTION 4: MAKING PACKAGES DYNAMIC LESSON 32: MAKING A PACKAGE DYNAMIC WITH VARIABLES 241 LESSON 33: MAKING A PACKAGE DYNAMIC WITH PARAMETERS 249 LESSON 34: MAKING A CONNECTION DYNAMIC WITH EXPRESSIONS 255 LESSON 35: MAKING A TASK DYNAMIC WITH EXPRESSIONS 261 SECTION 5: COMMON ETL SCENARIOS LESSON 36: LOADING DATA INCREMENTALLY 269 LESSON 37: USING THE CDC COMPONENTS IN SSIS 281 LESSON 38: USING DATA QUALITY SERVICES 295 LESSON 39: USING THE DQS CLEANSING TRANSFORM 309 LESSON 40: CREATING A MASTER PACKAGE 317 SECTION 6: CONTAINERS LESSON 41: USING SEQUENCE CONTAINERS TO ORGANIZE A PACKAGE 327 LESSON 42: USING FOR LOOP CONTAINERS TO REPEAT CONTROL FLOW TASKS 331 LESSON 43: USING THE FOREACH LOOP CONTAINER TO LOOP THROUGH A COLLECTION OF OBJECTS 337 SECTION 7: CONFIGURING PACKAGES LESSON 44: EASING DEPLOYMENT WITH CONFIGURATION TABLES 347 LESSON 45: EASING DEPLOYMENT WITH CONFIGURATION FILES 357 LESSON 46: CONFIGURING CHILD PACKAGES 365 SECTION 8: TROUBLESHOOTING SSIS LESSON 47: LOGGING PACKAGE DATA 375 LESSON 48: USING EVENT HANDLERS 381 LESSON 49: TROUBLESHOOTING ERRORS 387 LESSON 50: USING DATA VIEWERS 393 LESSON 51: USING BREAKPOINTS 399 SECTION 9: ADMINISTERING SSIS LESSON 52: CREATING AND CONFIGURING THE SSIS CATALOG 407 LESSON 53: DEPLOYING PACKAGES TO THE PACKAGE CATALOG 411 LESSON 54: CONFIGURING THE PACKAGES 415 LESSON 55: CONFIGURING THE SERVICE 421 LESSON 56: SECURING SSIS PACKAGES 425 LESSON 57: RUNNING SSIS PACKAGES 431 LESSON 58: RUNNING PACKAGES IN T-SQL AND DEBUGGING PACKAGES 437 LESSON 59: SCHEDULING PACKAGES 443 SECTION 10: LOADING A WAREHOUSE LESSON 60: DIMENSION LOAD 451 LESSON 61: FACT TABLE LOAD 459 SECTION 11: WRAP UP AND REVIEW LESSON 62: BRINGING IT ALL TOGETHER 465 APPENDIX A: SSIS COMPONENT CRIB NOTES 473 APPENDIX B: PROBLEM AND SOLUTION CRIB NOTES 477 APPENDIX C: WHAT''S ON THE DVD? 481 INDEX 483
Copyright Date
2013
Dewey Decimal
005.7585
Dewey Edition
23
Illustrated
Yes
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:145377362222
Shipping and handling
Item location:
Aurora, Illinois, United States
Ships to:
Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Comoros, Cook Islands, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Islas Malvinas), Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mayotte, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Puerto Rico, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Helena, Saint Kitts-Nevis, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Korea, Spain, Sri Lanka, Suriname, Svalbard and Jan Mayen, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Virgin Islands (U.S.), Wallis and Futuna, Western Sahara, Western Samoa, Worldwide, Yemen, Zambia, Zimbabwe
Excludes:
Barbados, French Guiana, French Polynesia, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free shipping | United States | Economy Shipping | Estimated between Sat, Jun 15 and Tue, Jun 18 to 43230 |
| US $15.99 | United States | Expedited Shipping | Estimated on or before Fri, Jun 14 to 43230 |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Seller feedback (5,214,817)
z***z (602)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
u***2 (279)- Feedback left by buyer.
Past 6 months
Verified purchase
Outstanding seller. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money.
Packaged and shipped well shows seller has concern for the products sold to arrive in excellent condition. The seller communicated timely with progress. Highly recommend this seller & will do business again. Thank you!!⭐️⭐️⭐️⭐️⭐️
a***r (328)- Feedback left by buyer.
Past 6 months
Verified purchase
thrift.books is an awesome place to purchase books! excellent communication! often the books arrive in better condition than described. ships very fast & the books arrive quickly! carefully packaged! +AAAAAAAAAA ebay sellers. i highly recommend thrift.books for people wanting to purchase books! reaasonable prices and shipping costs!