Search code examples
sql-serverssisteradatassis-2008attunity

SSIS TPT Import error

When i try to load data from excel source to the teradata with ssis and using microsoft connector for teradata by attunity 1.2 i got below error, what am i missing?

[Teradata Destination [23]] Error: TPT Import error encountered during Initiate phase. Could Not Find Message Catalog opermsgs [SSIS.Pipeline] Error: component "Teradata Destination" (23) failed the pre-execute phase and returned error code 0x80004005.

My configuration is:

  • SSIS 2008 R2
  • Teradata 15
  • Attunity 1.2
Solution

  • today I faced with the same error.

    My problem was solved, when I added a way to TPT folders in PATH runtime variable.

    This folders are:

    C:\Program Files\Teradata\client\14.10\Teradata Parallel Transporter\bin64;
C:\Program Files\Teradata\client\14.10\Teradata Parallel Transporter\msg64;
C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter\bin;
C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter\msg;