Microsoft Connector for Teradata for SQL Server 2019 is released

Published Nov 25 2019 12:33 AM 6,254 Views
Microsoft

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-toolbox.png

Teradata connection manager is displayed as "TERADATA".

Teradata-CM.png

 

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:

 

18 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-1118084%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118084%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20looking%20for%20the%20extension%20that%20installs%20the%20%22OData%20Source%22%20component%2C%20like%20in%20your%20screenshots.%20I'm%20using%20Visual%20Studio%202019%2C%20and%20I've%20already%20installed%20SSIS%20extension.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1119037%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457713%22%20target%3D%22_blank%22%3E%40ArmandoContestabile%3C%2FA%3E%26nbsp%3B%22OData%20Source%22%20is%20default%20component.%20Are%20you%20in%20the%20%22Data%20Flow%22%20tab%20in%20the%20design%20canvas%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1353057%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1353057%22%20slang%3D%22en-US%22%3E%3CP%3EGetting%20this%20error%20when%20trying%20to%20copy%20data%20from%20%22Teradata%20Source%22%20to%20%22OLE%20DB%20Destination%22%20(MSSQL%20Server).%20Have%20adjusted%26nbsp%3B%20%22JobMaxRowSize%22%20and%20tried%20to%20change%20the%20%22%3CSPAN%3EDiscardLargeRow%22%20to%20both%20true%20and%20false.%20ANy%20suggestions%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETITLE%3A%20Package%20Validation%20Error%3CBR%20%2F%3E------------------------------%3C%2FP%3E%3CP%3EPackage%20Validation%20Error%3C%2FP%3E%3CP%3E------------------------------%3CBR%20%2F%3EADDITIONAL%20INFORMATION%3A%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BTeradata%20Source%20%5B16%5D%5D%3A%20The%20%22Teradata%20Source%22%20is%20missing%20the%20required%20property%20%22JobMaxRowSize%22.%20The%20object%20is%20required%20to%20have%20the%20specified%20custom%20property.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BSSIS.Pipeline%5D%3A%20%22Teradata%20Source%22%20failed%20validation%20and%20returned%20validation%20status%20%22VS_ISCORRUPT%22.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BSSIS.Pipeline%5D%3A%20One%20or%20more%20component%20failed%20validation.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%3A%20There%20were%20errors%20during%20task%20validation.%3C%2FP%3E%3CP%3E(Microsoft.DataTransformationServices.VsIntegration)%3C%2FP%3E%3CP%3E------------------------------%3CBR%20%2F%3EBUTTONS%3A%3C%2FP%3E%3CP%3EOK%3CBR%20%2F%3E------------------------------%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BTeradata%20Source%20%5B16%5D%5D%3A%20The%20%22Teradata%20Source%22%20is%20missing%20the%20required%20property%20%22JobMaxRowSize%22.%20The%20object%20is%20required%20to%20have%20the%20specified%20custom%20property.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BSSIS.Pipeline%5D%3A%20%22Teradata%20Source%22%20failed%20validation%20and%20returned%20validation%20status%20%22VS_ISCORRUPT%22.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%20%5BSSIS.Pipeline%5D%3A%20One%20or%20more%20component%20failed%20validation.%3C%2FP%3E%3CP%3EError%20at%20Data%20Flow%20Task%3A%20There%20were%20errors%20during%20task%20validation.%3C%2FP%3E%3CP%3E(Microsoft.DataTransformationServices.VsIntegration)%3C%2FP%3E%3CP%3E------------------------------%3CBR%20%2F%3EProgram%20Location%3A%3C%2FP%3E%3CP%3Eat%20Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32%20flags%2C%20IOutputWindow%20outputWindow%2C%20DataTransformationsProjectConfigurationOptions%20options)%3CBR%20%2F%3Eat%20Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32%20launchOptions%2C%20ProjectItem%20startupProjItem%2C%20DataTransformationsProjectConfigurationOptions%20options)%3CBR%20%2F%3Eat%20Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32%20launchOptions)%3CBR%20%2F%3Eat%20Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32%20launchOptions%2C%20DataTransformationsProjectConfigurationOptions%20options)%3CBR%20%2F%3Eat%20Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32%20launchOptions%2C%20DataTransformationsProjectConfigurationOptions%20options)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1362440%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362440%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F644390%22%20target%3D%22_blank%22%3E%40Kahlejj%3C%2FA%3E%2C%20we%20have%20identified%20an%20issue%20occurs%20when%20you%20design%20a%20package%20containing%20Teradata%20components%20in%20SSDT%20and%20set%20the%20TargetServerVersion%20lower%20than%20SQL2019.%20In%20that%20scenario%2C%20if%20you%20try%20to%20execute%20the%20package%20in%20SSDT%2C%20you%20will%20get%20the%20valiation%20error%20about%20missing%20properties%20like%20what%20you%20described.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20that%20your%20case%3F%3C%2FP%3E%0A%3CP%3EWe%20are%20working%20on%20the%20fix%20and%20it%20will%20be%20ready%20soon.%3C%2FP%3E%0A%3CP%3ETemporary%20workaround%20for%20it%3A%20Instead%20of%20directly%20execute%20the%20package%2C%20close%20and%20reopen%20the%20package%20in%20the%20SSDT%20and%20then%20execute%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481818%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F471352%22%20target%3D%22_blank%22%3E%40Junxiao_Ma%3C%2FA%3E%26nbsp%3B-%20Is%20this%20connector%20tested%3F%20For%20some%20reason%20this%20doesn't%20work%20for%20us.%20Whenever%20I%20drag%20and%20drop%20the%20Teradata%20source%2C%20I%20get%20the%20following%20error.%20Can%20you%20please%20help%20with%20this%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bharathsql86_0-1592852466771.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200140i20D34EF3DDDD7D70%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22bharathsql86_0-1592852466771.png%22%20alt%3D%22bharathsql86_0-1592852466771.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1482992%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482992%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706943%22%20target%3D%22_blank%22%3E%40bharathsql86%3C%2FA%3E%26nbsp%3B-%20seems%20it%20indicates%20that%20the%20bits%20are%20registered%20but%20are%20somewhat%20located%20in%20the%20wrong%20location.%20Please%20try%20to%20uninstall%20and%20then%20reinstalled%20the%20Teradata%20Connector.%20Please%20also%20make%20sure%20you%20have%20installed%20Teradata%20tools%20and%20utilities.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520358%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520358%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20getting%20error%20while%20setting%20up%20the%20connection.%26nbsp%3BIt%20says%20-%26nbsp%3B%26nbsp%3BThere%20was%20an%20error%20trying%20to%20establish%20an%20Teradata%20connection%20with%20the%20database%20server.%3C%2FP%3E%3CP%3EWhen%20I%20check%20connection%20string%20property%20on%20properties%20-%20it%20says%20%3CSTRONG%3E%22Teradata%20ODBC%20Driver%20is%20not%20installed.%22%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22randomguy2020_3-1594705768182.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205137iCF7094C2E5A0952D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22randomguy2020_3-1594705768182.png%22%20alt%3D%22randomguy2020_3-1594705768182.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20setup%20is%20as%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22randomguy2020_4-1594706035331.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205138i535B0C3F43A58FB7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22randomguy2020_4-1594706035331.png%22%20alt%3D%22randomguy2020_4-1594706035331.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532977%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724500%22%20target%3D%22_blank%22%3E%40randomguy2020%3C%2FA%3E%2C%20we%20found%20there's%20an%20issue%20for%20supporting%20TTU17.00.%20Please%20uninstall%20the%20TTU17.00%20and%20just%20use%20the%20TTU16.20%20instead%20for%20now.%20We%20will%20have%20an%20update%20to%20support%20the%20TTU17.00.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550251%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550251%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20visual%20studio%202019%2C%20TTU%2016.20%2C%20and%20Microsoft%20Connector%201.0.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20able%20to%20use%20the%20Microsoft%20connector%20to%20pull%20data%20out%20of%20the%20Teradata%20and%20write%20to%20another%20database%20successfully.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20find%20the%20TD%20table%20I%20want%20to%20write%20to%2C%20in%20the%20Teradata%20Destination.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I'm%20having%20issues%20now%20attempting%20to%20write%20to%20Teradata%20due%20to%20the%20ErrorTableName%20property%20in%20the%20Teradata%20Destination.%26nbsp%3B%20%26nbsp%3BIf%20I%20leave%20it%20blank%2C%20it%20attempts%20to%20create%20the%20error%20file%20in%20my%20user%20database%2C%20where%20I%20don't%20have%20any%20space%20allocated.%26nbsp%3B%20If%20I%20add%20it%20without%20quotes%2C%20like%20databasename.tablename%20it%20tries%20to%20prefix%20the%20database%20name%20with%20SSIS_.%26nbsp%3B%20If%20I%20add%20it%20using%20quotes%20like%20%22DATABASENAME%22.%22TABLENAME%22%20it%20doesn't%20like%20the%20period%20between%20the%20database%20and%20table.%26nbsp%3B%20If%20I%20just%20use%20the%20database%20between%20double%20quotes%20it%20tries%20to%20add%20LOG%20to%20the%20end%20of%20it%20or%20at%20least%20I'm%20assuming%20it%20isn't%20jumping%20to%20another%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20actually%20trying%20to%20add%20LOG%20to%20the%20end%20of%20the%20value%20in%20ErrorTableName%20and%20how%20can%20I%20identify%20the%20database%20and%20table%20name%20to%20use%20for%20the%20error%20table%20when%20using%20the%20Teradata%20Destination%20to%20get%20it%20to%20work%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563753%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%20for%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563753%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20another%20problem%20with%20this.%3C%2FP%3E%3CP%3EI%20have%20to%20transfere%20a%20lot%20of%20data%20from%20TERADATA%20to%20SQL%20SERVER%202019%20to%20use%20columnstore%20index.%20My%20TERADATA%20server%20is%20overload.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESQL%20Server%202019%20in%20Windows%20Cluster.%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20SQL%20Server%202019%20(RTM-CU5)%20(KB4552255)%20-%2015.0.4043.16%20(X64)%26nbsp%3B%20Enterprise%20Edition%3A%20Core-based%20Licensing%20(64-bit)%20on%20Windows%20Server%202019%20Datacenter%2010.0%20%3CX64%3E%20(Build%2017763%3A%20)%3C%2FX64%3E%3C%2FP%3E%3CP%3E------------------------------------------------------------%3C%2FP%3E%3CP%3ETTU%20version%26nbsp%3B16.20.00.00%3C%2FP%3E%3CP%3E------------------------------------------------------------%3C%2FP%3E%3CP%3ESQL%20Server%20integration%20Services%20Teradata%20Connector%20version%2015.0.2000.118%20x86%20and%20x64%3C%2FP%3E%3CP%3E------------------------------------------------------------%3C%2FP%3E%3CP%3EVisual%20studio%202019%26nbsp%3B%20Microsoft%20Visual%20Studio%20Community%202019%20Version%2016.6.5%3C%2FP%3E%3CP%3EProjectServicesPackage%20Visual%20Studio%20Extension%20Detailed%20Info%3C%2FP%3E%3CP%3ESQL%20Server%20Data%20Tools%2016.0.62006.03190%3CBR%20%2F%3EMicrosoft%20SQL%20Server%20Data%20Tools%3C%2FP%3E%3CP%3ESQL%20Server%20Integration%20Services%2015.0.2000.123%3CBR%20%2F%3EMicrosoft%20SQL%20Server%20Integration%20Services%20Designer%3CBR%20%2F%3EVersion%2015.0.2000.123%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAND%3C%2FP%3E%3CP%3EI%20can%20not%20transfer%20data%20from%20teradata%20to%20SQL%20SERVER%202019.%3C%2FP%3E%3CP%3EI%20recebe%20this%20error%26nbsp%3B%3C%2FP%3E%3CP%3EError%3A%200xC000C13A%20at%20Data%20Flow%20Task%2C%20Teradata%20Source%20%5B25%5D%3A%20An%20error%20occurred%20when%20converting%20string%20to%20target%20codepage.%20Column%20name%20is%20%5BCOLUM_NAME%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20is%20transfer%20to%20sql%20server%20but%20the%20execution%20finish%20with%20ERROR.%3C%2FP%3E%3CP%3EWarning%3A%200x80019002%20at%20Data%20Flow%20Task%3A%20SSIS%20Warning%20Code%20DTS_W_MAXIMUMERRORCOUNTREACHED.%20The%20Execution%20method%20succeeded%2C%20but%20the%20number%20of%20errors%20raised%20(10413)%20reached%20the%20maximum%20allowed%20(1)%3B%20resulting%20in%20failure.%20This%20occurs%20when%20the%20number%20of%20errors%20reaches%20the%20number%20specified%20in%20MaximumErrorCount.%20Change%20the%20MaximumErrorCount%20or%20fix%20the%20errors.%3CBR%20%2F%3ETask%20failed%3A%20Data%20Flow%20Task%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1029633%22%20slang%3D%22en-US%22%3EMicrosoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1029633%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EMicrosoft%20Connector%20for%20Teradata%26nbsp%3Bis%20the%20replacement%20of%20Attunity%20Teradata%20Connector%20starting%20from%20SQL%20Server%202019%20and%20now%20it%20is%20released%20for%20preview.%20Microsoft%20Connector%20for%20Teradata%20provides%20compatibility%20with%20Attunity%20Teradata%20Connector%20in%20functionality%20and%20performance.%20Packages%20designed%20with%20Attunity%20Teradata%20Connector%20can%20run%20with%20Microsoft%20Connector%20for%20Teradata%20without%20any%20changes.%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3EInstallation%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3EPrerequisite%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETeradata%20ODBC%20driver%20and%20Teradata%20Parallel%20Transporter%20supported%20versions%20are%20installed%20from%20%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdownloads.teradata.com%2Fdownload%2Ftools%2Fteradata-tools-and-utilities-windows-installation-package%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ETeradata%20tools%20and%20utilities%20download%20site%3C%2FA%3E.%20Supported%20Teradata%20PT%20versions%20are%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETeradata%20Parallel%20Transporter%20(Teradata%20PT)%2016.10%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETeradata%20Parallel%20Transporter%20(Teradata%20PT)%2016.20%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3EGo%20to%20document%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdata-flow%2Fteradata-connector%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Epage%3C%2FA%3E%20for%20more%20details.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETo%20install%20the%20connector%20for%20Teradata%20database%2C%20download%20and%20run%20the%20installer%20from%20-ERR%3AREF-NOT-FOUND-the%20latest%20version%20of%20Microsoft%20connector%20for%20Teradata.%20Then%20follow%20the%20directions%20in%20the%20installation%20wizard.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3EAfter%20you%20install%20the%20connector%2C%20you%20must%20restart%20the%20SQL%20Server%20Integration%20Service%20to%20be%20sure%20that%20the%20Teradata%20source%20and%20destination%20works%20correctly.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3EDesign%20and%20execute%20SSIS%20packages%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3EMicrosoft%20Connector%20for%20Teradata%20provides%20similar%20user%20experience%20with%20Attunity%20Teradata%20Connector.%20User%20can%20design%20new%20packages%20based%20on%20previous%20experience%2C%20using%20SSDT%20for%20VS%202017%20since%2015.9.0%20or%20SSIS%20Projects%20for%20VS%202019%2C%20with%20targeting%20SQL%20server%202019.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETeradata%20source%20and%20destination%20are%20under%20Common%20category.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22teradata-toolbox.png%22%20style%3D%22width%3A%20365px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158722i49FBF58D20B52B2A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22teradata-toolbox.png%22%20alt%3D%22teradata-toolbox.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETeradata%20connection%20manager%20is%20displayed%20as%20%22TERADATA%22.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Teradata-CM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158724iA1821F197E85D67C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Teradata-CM.png%22%20alt%3D%22Teradata-CM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3EExisting%20SSIS%20packages%20which%20have%20been%20designed%20with%20Attunity%20Teradata%20Connector%20will%20be%20automatically%20upgraded%20to%20use%20Microsoft%20Connector%20for%20Teradata.%20The%20icons%20will%20be%20changed%20as%20well.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20margin%3A%200px%3B%22%3ETo%20design%20SSIS%20package%20targeting%20SQL%20Server%202017%20and%20below%2C%20you%20will%20need%20to%20have%20%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3EMicrosoft%20Connector%20for%20Teradata%3C%2FSTRONG%3E%20and%20install%20%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3EMicrosoft%20Connector%20for%20Teradata%20by%20Attunity%3C%2FSTRONG%3E%20with%20corresponding%20version%20from%20below%20link%3A%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20clear%3A%20left%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20list-style-image%3A%20none%3B%20list-style-position%3A%20outside%3B%20list-style-type%3A%20disc%3B%20margin-bottom%3A%2012px%3B%20margin-top%3A%200px%3B%20orphans%3A%202%3B%20padding-left%3A%202.5em%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%0A%3CLI%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-weight%3A%20400%3B%22%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D55179%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%202017%3A%20Microsoft%20Connector%20Version%205.0%20for%20Teradata%20by%20Attunity%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-weight%3A%20400%3B%22%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D52950%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%202016%3A%20Microsoft%20Connector%20Version%204.0%20for%20Teradata%20by%20Attunity%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-weight%3A%20400%3B%22%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D44582%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%202014%3A%20Microsoft%20Connector%20Version%203.0%20for%20Teradata%20by%20Attunity%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-weight%3A%20400%3B%22%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D29283%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%202012%3A%20Microsoft%20Connector%20Version%202.0%20for%20Teradata%20by%20Attunity%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1029633%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20Connector%20for%20Teradata%26nbsp%3Bis%20the%20replacement%20of%20Attunity%20Teradata%20Connector%20starting%20from%20SQL%20Server%202019%20and%20now%20it%20is%20released.%20Microsoft%20Connector%20for%20Teradata%20provides%20compatibility%20with%20Attunity%20Teradata%20Connector%20in%20functionality%20and%20performance.%20Packages%20designed%20with%20Attunity%20Teradata%20Connector%20can%20run%20with%20Microsoft%20Connector%20for%20Teradata%20without%20any%20changes.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570067%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570067%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741584%22%20target%3D%22_blank%22%3E%40simee5%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EIt%20is%20a%20limitation%20now%20that%20the%20error%20table%20can%20only%20be%20created%20in%20the%20user%20database.%20It%20does%20not%20recognize%20the%20%5Bschema%5D.%5Btablename%5D%20format.%20We%20will%20provide%20a%20fix%20for%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1654875%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1654875%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20another%20issue%20now.%26nbsp%3B%20We%20used%20to%20be%20able%20to%20pull%20from%20views%20using%20the%20old%20Attunity%20connectors%2C%20but%20now%20it%20seems%20that%20a%20Teradata%20Source%20will%20only%20list%20tables%20from%20Teradata%20and%20not%20allow%20me%20to%20select%20a%20view.%26nbsp%3B%20Is%20there%20a%20way%20to%20pull%20data%20from%20Teradata%20using%20the%20new%20Microsoft%20connector%20for%20Teradata%20and%20views%2C%20since%20those%20are%20how%20we%20get%20access%20to%20the%20data%20in%20the%20underlying%20tables%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1655729%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741584%22%20target%3D%22_blank%22%3E%40simee5%3C%2FA%3E%26nbsp%3BCan%20you%20use%20below%20work-around%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETeradata%26nbsp%3BSource%26nbsp%3BEditor%2C%20view%26nbsp%3Bcannot%26nbsp%3Bbe%26nbsp%3Bdisplayed%26nbsp%3Bwhen%26nbsp%3BData%26nbsp%3Baccess%26nbsp%3Bmode%26nbsp%3Bis%26nbsp%3B%22Table%26nbsp%3BName%26nbsp%3B%E2%80%93%26nbsp%3BTPT%26nbsp%3BExport%22.%20As%26nbsp%3Bwork-around%2C%26nbsp%3Buse%26nbsp%3BAdvanced%26nbsp%3BEditor%26nbsp%3Bof%26nbsp%3BTeradata%26nbsp%3BSource.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fintegration-services%2Fdata-flow%2Fteradata-connector%3Fview%3Dsql-server-2017%23limitationsandknownissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fintegration-services%2Fdata-flow%2Fteradata-connector%3Fview%3Dsql-server-2017%23limitationsandknownissues%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1751369%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1751369%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20having%20the%20same%20issue%20as%20user%20(%40simee5)%20regarding%20the%20Teradata%20error%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20mentioned%20a%20fix%20was%20coming%20for%20this%20issue%20-%20has%20that%20been%20released%3F%20If%20so%2C%20where%20can%20we%20update%20our%20drivers%2Ftools%20to%20bring%20in%20this%20new%20change%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%2C%20is%20there%20an%20ETA%20on%20when%20the%20fix%20will%20be%20made%20available%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3EJordan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2197472%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Teradata%20for%20SQL%20Server%202019%20is%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2197472%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20issue%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F816898%22%20target%3D%22_blank%22%3E%40Jordan_Haymond%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741584%22%20target%3D%22_blank%22%3E%40simee5%3C%2FA%3E%26nbsp%3B%20with%20the%20error%20tables.%26nbsp%3B%20Have%20you%20made%20any%20progress%20on%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20run%20the%20old%20Attunity%20drivers%20on%20SQL%20Server%202019%20enterprise%3F%26nbsp%3B%20I%20have%20a%20version%20running%20on%20an%20old%202012%20Sql%20server%20using%20the%26nbsp%3BAttunity%20drivers%20but%20we%20are%20retiring%20that%20box%20soon%20and%20I%20am%20going%20to%20loose%20a%20bunch%20of%20ETL%20jobs%20if%20we%20cant%20get%20the%20error%20table%20fixed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Aug 03 2020 04:20 PM
Updated by: