MicrosoftI have another problem with this.
I have to transfere a lot of data from TERADATA to SQL SERVER 2019 to use columnstore index. My TERADATA server is overload.
SQL Server 2019 in Windows Cluster.
Microsoft SQL Server 2019 (RTM-CU5) (KB4552255) - 15.0.4043.16 (X64) Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: )
------------------------------------------------------------
TTU version 16.20.00.00
------------------------------------------------------------
SQL Server integration Services Teradata Connector version 15.0.2000.118 x86 and x64
------------------------------------------------------------
Visual studio 2019 Microsoft Visual Studio Community 2019 Version 16.6.5
ProjectServicesPackage Visual Studio Extension Detailed Info
SQL Server Data Tools 16.0.62006.03190
Microsoft SQL Server Data Tools
SQL Server Integration Services 15.0.2000.123
Microsoft SQL Server Integration Services Designer
Version 15.0.2000.123
AND
I can not transfer data from teradata to SQL SERVER 2019.
I recebe this error
Error: 0xC000C13A at Data Flow Task, Teradata Source [25]: An error occurred when converting string to target codepage. Column name is [COLUM_NAME].
The data is transfer to sql server but the execution finish with ERROR.
Warning: 0x80019002 at Data Flow Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (10413) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: Data Flow Task
