I have installed the 64bit Teradata connector v1.0 and I am getting the following error when running SSIS package:
The Teradata TPT registry key cannot be opened. Verify that the TPT API 12.0 for Windows x64 is installed properly.
I checked and verified that the 64bit TPT API v184.108.40.206 is installed.
The 64bit Teradata connector v1.0 requires the following Teradata components:
- 64bit Teradata ODBC Driver
- 64bit TPT API version 12.0 with the following operators:
The connector searches for the TPT API v12.0 registry key when trying to find the TPT API installation directory.
The exact registry entry being searched is:
HKEY_LOCAL_MACHINE\SOFTWARE\NCR\Teradata Parallel Transporter API x8664 12.0
The 64bit TPT API v220.127.116.11 has the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\NCR\Teradata Parallel Transporter API x8664 18.104.22.168
Because of the extra minor version number (0.3) in the key name, the connector fails to find the registry key and returns the error mentioned above.
The solution is to duplicate the Teradata Parallel Transporter API x8664 22.214.171.124 registry key and name it Teradata Parallel Transporter API x8664 12.0. The content of the key should be the same as the original key.
This will enable the Teradata connector to find the TPT key and to read the TPT installation directory.