Share via

SSIS 2019/2022 - Teradata 20.00 - Microsoft Teradata Connector - Source and Destination not showing in SSIS Toolbox after installation

Susann 0 Reputation points
2026-04-29T15:20:20.2533333+00:00

I have to upgrade to Teradata 20.00 and cannot get the Teradata Source and Destination Tools to show up in SSIS 2022 with VS2022. I have tried with the packages targeting 2019 and 2022. The installation of the connector itself claims to have been completed successfully.

I have currently installed (In the order listed):

Microsoft Visual Studio Community 2022 Version 17.14.31 (April 2026)

SQL Server Data Tools 17.14.26.0

SQL Server Integration Services 17.0.1016.0

Teradata Tools And Utilities (all modules) 20.00.34.00

MicrosoftTeradataConnector_SQL2019_r285Microsoft

TeradataConnector_SQL2022_r285

Based on past experience this is likely due to one of the following reasons:

  • One or more of the components installed do not have the build version that the connector needs.
  • The connector does not work in Visual Studio Community Edition.
  • Old registry entries from either SSIS or Teradata that did not cleanup properly when uninstalling the versions that had been previously installed on the same server.

Can anyone provide me with a detailed version list  (like above) of a working installation that allows me to adjust my installation?

Thank you in advance!

SQL Server Integration Services

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-04-29T15:21:00.58+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    Teradata Source and Destination not appearing in the SSIS Toolbox is typically caused by a version/target mismatch between:

    • Visual Studio / SSDT (SSIS Projects extension)
    • TargetServerVersion of the SSIS project
    • Installed Microsoft Teradata Connector
    • (For pre‑2019 targets) installed Attunity Teradata connectors

    From the available information, the key requirements are:

    1. Install TTU and Microsoft Teradata Connector correctly
    • Teradata Tools and Utilities (TTU) 20.00 must be installed, including:
      • ODBC Driver for Teradata
      • Teradata Parallel Transporter (TPT)
    • Then install the Microsoft Connector for Teradata using the latest installer.
    • After installation, restart the SQL Server Integration Service so Teradata source/destination components load correctly.

    Relevant details:

    • Microsoft Connector for Teradata depends on TTU 20.00.
    • TTU has discontinued 32‑bit TPT; the connector has therefore dropped 32‑bit and Visual Studio 2019 support.
    • The TTU 17.10‑based rev. 284 is the last version that supports 32‑bit and VS2019; newer revs (such as r285) are for 64‑bit/VS2022 scenarios.
    1. Ensure the SSIS project target and connector versions align
    • For SSIS packages targeting SQL Server 2019 or 2022:
      • Use the new Microsoft Connector for Teradata (rev. 285) with TTU 20.00.
      • Teradata Source and Destination appear under the Common category in the SSIS Toolbox when the connector is correctly installed.
    • For SSIS packages targeting SQL Server 2017 or earlier:
      • In addition to the Microsoft Teradata Connector, the corresponding “Microsoft Connector for Teradata by Attunity” must be installed for the target version:
        • SQL Server 2017: Microsoft Connector v5.0 for Teradata by Attunity
        • SQL Server 2016: Microsoft Connector v4.0 for Teradata by Attunity
        • SQL Server 2014: Microsoft Connector v3.0 for Teradata by Attunity
        • SQL Server 2012: Microsoft Connector v2.0 for Teradata by Attunity
      • This requirement applies even when designing packages in newer SSDT/VS versions.
    1. Match SSDT/SSIS extension version and Attunity connector (for pre‑2019 targets)
    • When using Attunity connectors, the version of the connectors must match the SSDT/SSIS designer version, independent of the SQL Server target version.
    • Example from the documented matrix:
      • SSDT version 17 (build starts with 14, for SQL Server 2017) requires Microsoft Connectors v5.0 for Oracle and Teradata.
    1. Visual Studio/SSIS extension support
    • The new Microsoft Connector for Teradata supports:
      • SQL Server 2022
      • SQL Server 2019
      • SQL Server 2025
      • SQL Server Integration Services Projects for Visual Studio 2022
    • Visual Studio 2019 is no longer supported by the TTU 20.00‑based connector due to the removal of 32‑bit TPT.
    1. Troubleshooting when Teradata components do not appear
    • Verify that:
      • TTU 20.00 is installed with ODBC Driver for Teradata and Teradata Parallel Transporter.
      • The latest Microsoft Connector for Teradata is installed for SQL Server 2019/2022.
      • For projects targeting SQL Server 2017 or earlier, the matching Attunity connector version is also installed.
      • The SSIS project’s TargetServerVersion matches the intended SQL Server version.
    • If the connectors still do not appear in the SSIS Toolbox:
      • Confirm that the correct connector version for the installed SSDT/SSIS extension is present (for Attunity scenarios).
      • Restart Visual Studio and ensure the SSIS extension is loaded.
    1. Example of a valid configuration (from documentation)

    A working configuration for Teradata with SSIS (for SQL Server 2019/2022 targets) includes:

    • Visual Studio 2022 with SSIS Projects extension
    • TTU 20.00 with ODBC Driver for Teradata and Teradata Parallel Transporter installed
    • Latest Microsoft Connector for Teradata (TTU 20.00‑based, rev. 285)
    • SSIS project targeting SQL Server 2019 or 2022

    Under this configuration, Teradata Source and Teradata Destination appear in the SSIS Toolbox under the Common category, and the Teradata connection manager type appears as “TERADATA”.

    References:

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.