This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 51%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Hi there, I installed 'Microsoft connector for Teradata' to use 'teradata Source' component within dataflow task but its not working when I try to add this :
TITLE: Microsoft Visual Studio
The component could not be added to the Data Flow task.
Could not initialize the component. There is a potential problem in the ProvideComponentProperties method.
ADDITIONAL INFORMATION:
Error at Data Flow Task [SSIS.Pipeline]: The module containing ", clsid {A21403DF-47CD-4066-A4AD-035C53DAE8E9}" cannot be located, even though it is registered.
Error at Data Flow Task [ [1]]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)
BUTTONS:
OK
Current version of software:
VS2019 16.10.3 + SSDT 16.0.62106.24090
VS2017 15.9.36 + SSDT 15.1.62002.01090
In the beginning:
I had already installed Teradata TTU 17.00.00
Steps I tried to remediate that error but no positive result
1) Installed latest Teradata TTU 17.10.06.00 - didn't help
2) Re-Installed Microsoft Connector Version 4.0 for Oracle and Teradata by Attunity targeting SQL Server 2017 - no luck
3) Re-installed 'Microsoft connector for Teradata' -no luck
4) Uninstalled both 'Microsoft Connector Version 4.0 for Oracle and Teradata by Attunity' and 'Microsoft connector for Teradata' and
Installed 'Microsoft connector for Teradata' - didn't help
5) Tried to reinstall 'Microsoft Connector Version 5.0 for Oracle and Teradata by Attunity' and 'Microsoft connector for Teradata' - didn't help
Tried both x64 and x86 versions - get the same error all time.
6) Tried to switch SQL server targeted version from 2016 => 2019 and back. DIdn't help
7) Tried to switch run64bitruntime debugging option to false - didn't help
In both VS 2017 and VS 2019 I get the same error.
Any ideas how I can resolve this?
Hi @Kikot, Pavel , welcome to Microsoft Q&A! Have you check the Limitations and known issues:
○ Teradata Source/Destination Editor, Default database property does not take effective. As work-around, type database name in dropdown box to filter table or view.
○ Teradata Source/Destination Editor, Mapping step does not work when type <database>.<table/view>. As work-around, type <database>.<table/view>, then click the drop-down button.
○ Teradata Source Editor, view cannot be displayed when Data access mode is "Table Name – TPT Export". As work-around, use Advanced Editor of Teradata Source.
○ Teradata Destination, attribute ‘PackMaximum’ cannot be set to ‘True’. Otherwise, error will occur.
And after you install Microsoft Connector for Teradata, you must restart the SQL Server Integration Service to be sure that the Teradata source and destination works correctly. I try to install connector and restart SSIS, there is no issues in my side (SQL Server 2017 and SSDT 2017). Please refer to this blog.
Hi @CarrinWu-MSFT , When I design a package I cannot add the 'Teradata Source' component on the field as it throws the error described above. Basically, I think it is a bug within installation 'Microsoft connector for Teradata'. Some library/dlls are not got registered correctly in the system.
Hi @Kikot, Pavel , I am use SQL Server 2017 and SSIS 2017, could add Teradata Source to Data Flow as below:
If you think this is a bug, suggest you post your issue in Microsoft feedback: https://feedback.azure.com/forums/908035-sql-server .
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 14.000000000000002%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ3%3C/text%3E%3C/svg%3E)
I got past this error by installing
Using Windows 10, VS 2019, and SQL 2019.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hi @Kikot, Pavel ,
Just wanted to check, have you got the solution for this issue.
we are also facing the same issue.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 70%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
I have the same issue @Kikot, Pavel , @CarrinWu-MSFT - Did you fine any solutions to this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Hi Sree, we are hit by the same issue. Did you find a solution yet ?