Microsoft SQL Server 2000 Data Transformation Services- P16

Microsoft SQL Server 2000 Data Transformation Services- P16: Data Transformation Services in Microsoft SQL Server 2000 is a powerful tool for movingdata. It’s easy to use, especially when you’re creating transformation packages with the DTSWizard. But it’s also a flexible tool that you can customize to gain a high degree of controlover the transformation of your data.
Nội dung trích xuất từ tài liệu:
Microsoft SQL Server 2000 Data Transformation Services- P16 SQL statements702 SQL statements, 506 tasks, 470 T assigning, 366 transactions, 484-485, modifying, 300-301 487-490, 493 tables objects, 503, 513-514 stored procedures, 339 Bulk Insert task, 283 properties, 294 Execute SQL task, 301 copying, 516 queries, 372-373 moving, 311 data, 89 staging area, 89-90 packages, 18-19 staging area, 89-90 properties, 546-549 Data Driven Query task, star schema 220-222 dimension tables, 85 storing databases, 310 fact tables, 78-79, 82, Called Package, 385 indexes, 584-585 92 data, 60, 72-74, 76 locking, 283-284, 578 modeling, 81-82 DTS packages, 14-15 moving, 92, 311 storage, 74 error messages, 340 sources, 131 see also dimension error records, 557-558 transformations, 251 tables meta data, 334 see also dimension starting custom trans- packages, 438, 445-451 tables formations, 664-665 strings task logs, 358-359 StartTime property, 497 data, 197 empty, 203-204 Task object, 27 status, transforma- assignments, 371 manipulating, 202-203 tions, 188, 207 collections, 624 receiving, 396 Step object, 27, 612 sending, 392 creating, 11-12, 335, collection, 624 Transformation Flags 536, 620-621 creating, 470 dialog, 145 custom, 634-637 disabling, 480 hierarchy, 614 structured storage file, executing, 458, 471, naming, 497 15 476-477 priorities, 12-13, 479 Join Transaction If Subject property, 407 programmatic identi- Present, 484 subordinate dimen- fiers, 621-623 lineage, 605-606 sions properties, 615-616, naming, 471, 474 creating, 98 619, 621 packages, 478-481 keys, 85, 88, 92 referencing, 349-350, Parent, 479, 496-497 splitting, 95-97 620 precedence constraints, subsets, 249 steps, 470 471 threads, 477 SuccessReturn prop- properties, 470, 477, transactions, 486-487 erty, 428 480, 496-497 see also custom tasks referencing, 349-350 summarization, 37 technical meta data, system information, 589 339, 627-628 Transform Data task 703templates, 32-33, 42, 54 TransactionIsolation Transfer Jobs task, 46,terminating Level property, 465 338-339 Enterprise manager, transactions Transfer Logins task, 561-563 chaos, 483 46, 337, 623 Package manager, child packages, 379 Transfer Master Stored 561-563 Commit On option, 482 Procedure Properties packages, 454, 481, 555 connections, 480, 486- task, 45, 339, 623 processes, 428 487 Transfer MSDB Jobstesting errors, 558 task, 623 scripts, 187 isolation levels, 483-484 joining, 482, 484 Transfer Object task, transformations, 146 packages, 493 50, 317-323text files parallel processing, Transform Data task, ActiveX scripts, 172 490-493 40, 47 bcp utility, 585 parent packages, 379 aborting, 191 binary, 427 processing, 63-64 bulk inserting, 268 connections, 115-119 rollback, 491-493 collections, 350 data, 569-570 ...