The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
© 2009 Microsoft Corporation. All rights reserved.
All other trademarks are property of their respective owners.
1
Introduction 27
Architecture 28
Prerequisites and Installation 29
SQL Server Components 29
Required Teradata Components 29
Installation 31
General Configuration in SQL Server Business Intelligence Development Studio 33
Enabling Teradata Source and Teradata Destination as Data Flow Toolbox Items 33
Configuring the Teradata Connection Manager 33
Use Case 1: Bulk Unload from Teradata to SQL Server Using TPT Export 35
Use Case Architecture Overview 35
Description 35
Defining the SQL Server Integration Services Data Flow 35
Configuring the Teradata Source Component 35
Choosing the Data Access Mode 38
Adding and Configuring the Destination Component 38
Use Case 2: Bulk Load into Teradata Using TPT Load 38
Use Case 2 Architecture Overview 38
Description 39
Defining the SQL Server Integration Services Data Flow 39
Adding and Configuring Source and Teradata Destination Components 39
Use Case 3: Incremental Load into Teradata Using TPT Stream 39
Description 39
Architecture 40
Defining the SQL Server Integration Services Data Flow 40
Adding and Configuring Source and Teradata Destination Components 40
Conclusion 40
Appendix A – Data Types 42
Supported Data Types 42
Data Type Mapping 42
Appendix B – Teradata Source Advanced Topics 46
Teradata Source 46
Error Handling 46
Parallelism 46
Troubleshooting the Teradata Source 46
Configuring the Teradata Source 47
Teradata Source Editor (Connection Manager Page) 47
Teradata Source Editor (Columns Page) 48
Teradata Source Editor (Error Output Page) 48
Teradata Source Advanced Editor 49
Teradata Source Custom Properties 49
Appendix C – Teradata Destination Component Advanced Topics 53
Teradata Destination 53
Load Options 53
Error Handling 53
Parallelism 55
Troubleshooting the Teradata Destination 55
Configuring the Teradata Destination 55
Teradata Destination Editor (Connection Manager Page) 56
Teradata Destination Editor (Mappings Page) 57
Teradata Destination Editor (Error Output Page) 58
Teradata Destination Advanced Editor 59
Teradata Destination Custom Properties 59
Appendix D – Troubleshooting Run-Time Failures 61
STEP 1– Eliminate the Common Problems 62
STEP 2 - Using the Logging Facility 62
STEP 3 - Understanding the Log File 63