TPT Help with SSIS

Connectivity
Enthusiast

TPT Help with SSIS

TPT Help with SSIS

Hello All,

I just installed the Teradata 15.0 driver on one of the servers. Now I am able to connect to the TeraData DB and see all the drivers.

When I try to run the package, it complains that I am missing the TPT API. Fair enough. I downloaded the TTU 15.0 from the Teradata website and I am trying to follow 

http://www.attunity.com/forums/microsoft-ssis- teradata-connector/error-teradata-tpt-registry-key- cannot-1434.html article to recover from issues. 

I dont see the 1) Load and 2) Export TPT packages in there? What am I missing. I only want to install what is required and do not want to bloat my system. 

Please suggest what all I need to install so that I can pass it on to the DBA's who have admin rights on the system.

Thanks,

Rajiv.




Tags (1)
2 REPLIES
Enthusiast

Re: TPT Help with SSIS

Maybe you can post your issues in attunity forum too.  ODBC operator for tpt is certified to work only with the DataDirect/Progress ODBC drivers. Others may work but may produce unwanted results.

Teradata Employee

Re: TPT Help with SSIS

You need to install:

 

- MS SSIS Connector for Teradata (note, different connector rel. exists for SQL Server IS versions) 

- Teradata ODBC (32 and 64) (metadata/schema interrogation)

- Teradata TPT Base and Stream 

 

See SSIS and Teradata paper at http://www.teradata.com/Resources/White-Papers/Microsoft-SQL-Server-2012-Integration-Services-and-Te... (dated, but applicable for general overview re: integration)