Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

Microsoft Connector for Teradata for SQL Server 2019 is released

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Nov 25, 2019

Microsoft Connector for Teradata is the replacement of Attunity Teradata Connector starting from SQL Server 2019 and now it is released for preview. Microsoft Connector for Teradata provides compatibility with Attunity Teradata Connector in functionality and performance. Packages designed with Attunity Teradata Connector can run with Microsoft Connector for Teradata without any changes.

 

Installation

Prerequisite

Teradata ODBC driver and Teradata Parallel Transporter supported versions are installed from Teradata tools and utilities download site. Supported Teradata PT versions are: 

Teradata Parallel Transporter (Teradata PT) 16.10

Teradata Parallel Transporter (Teradata PT) 16.20

Go to document page for more details.

 

To install the connector for Teradata database, download and run the installer from the latest version of Microsoft connector for Teradata. Then follow the directions in the installation wizard.

After you install the connector, you must restart the SQL Server Integration Service to be sure that the Teradata source and destination works correctly.

 

Design and execute SSIS packages

Microsoft Connector for Teradata provides similar user experience with Attunity Teradata Connector. User can design new packages based on previous experience, using SSDT for VS 2017 since 15.9.0 or SSIS Projects for VS 2019, with targeting SQL server 2019.

Teradata source and destination are under Common category.

Teradata connection manager is displayed as "TERADATA".

 

Existing SSIS packages which have been designed with Attunity Teradata Connector will be automatically upgraded to use Microsoft Connector for Teradata. The icons will be changed as well.

 

To design SSIS package targeting SQL Server 2017 and below, you will need to have Microsoft Connector for Teradata and install Microsoft Connector for Teradata by Attunity with corresponding version from below link:

 

Updated Aug 03, 2020
Version 3.0

27 Comments

Show More
  • randomguy2020's avatar
    randomguy2020
    Copper Contributor
    Jul 14, 2020

    Hi, I am getting error while setting up the connection. It says -  There was an error trying to establish an Teradata connection with the database server.

    When I check connection string property on properties - it says "Teradata ODBC Driver is not installed." 

     

     

    My setup is as below:

     

     

     

    Can you please help me with this?

     

    Thanks!

  • Junxiao_Ma's avatar
    Junxiao_Ma
    Former Employee
    Jun 23, 2020

    Hi bharathsql86 - seems it indicates that the bits are registered but are somewhat located in the wrong location. Please try to uninstall and then reinstalled the Teradata Connector. Please also make sure you have installed Teradata tools and utilities. 

  • bharathsql86's avatar
    bharathsql86
    Copper Contributor
    Jun 22, 2020

    Junxiao_Ma - Is this connector tested? For some reason this doesn't work for us. Whenever I drag and drop the Teradata source, I get the following error. Can you please help with this

     

  • Junxiao_Ma's avatar
    Junxiao_Ma
    Former Employee
    May 06, 2020

    Kahlejj, we have identified an issue occurs when you design a package containing Teradata components in SSDT and set the TargetServerVersion lower than SQL2019. In that scenario, if you try to execute the package in SSDT, you will get the valiation error about missing properties like what you described. 

    Is that your case?

    We are working on the fix and it will be ready soon.

    Temporary workaround for it: Instead of directly execute the package, close and reopen the package in the SSDT and then execute it.

  • Kahlejj's avatar
    Kahlejj
    Copper Contributor
    May 01, 2020

    Getting this error when trying to copy data from "Teradata Source" to "OLE DB Destination" (MSSQL Server). Have adjusted  "JobMaxRowSize" and tried to change the "DiscardLargeRow" to both true and false. ANy suggestions? 

     

    TITLE: Package Validation Error
    ------------------------------

    Package Validation Error

    ------------------------------
    ADDITIONAL INFORMATION:

    Error at Data Flow Task [Teradata Source [16]]: The "Teradata Source" is missing the required property "JobMaxRowSize". The object is required to have the specified custom property.

    Error at Data Flow Task [SSIS.Pipeline]: "Teradata Source" failed validation and returned validation status "VS_ISCORRUPT".

    Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

    Error at Data Flow Task: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

     

    ===================================

    Error at Data Flow Task [Teradata Source [16]]: The "Teradata Source" is missing the required property "JobMaxRowSize". The object is required to have the specified custom property.

    Error at Data Flow Task [SSIS.Pipeline]: "Teradata Source" failed validation and returned validation status "VS_ISCORRUPT".

    Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

    Error at Data Flow Task: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    ------------------------------
    Program Location:

    at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

  • ArmandoContestabile's avatar
    ArmandoContestabile
    Copper Contributor
    Jan 20, 2020

    Hello, I'm looking for the extension that installs the "OData Source" component, like in your screenshots. I'm using Visual Studio 2019, and I've already installed SSIS extension. Thank you.