SSIS 2008 Vs Teradata Via .NET Driver

Connectivity

SSIS 2008 Vs Teradata Via .NET Driver

Hi,

I am trying to pull somedata from Teradata 12 by SSIS 2008 using .NET provider for Teradata 13...02 on 64Bit Windows Server.

I can save and add connection managers (and also "Test Connection" was successful) but when i try to execute my package, it immediately fails by giving the error below:

Here is the output window for SSIS Package:

------------------------------------------------

SSIS package "Import stores.dtsx" starting.
Information: 0x4004300A at Stores, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at Stores, ADO NET Source 1 [9891]: Teradata.Client.Provider.TdException: [.NET Data Provider for Teradata] [115009] Message truncation error, not all data was received.
at Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
at Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout)
at Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout)
at Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout)
at Teradata.Client.Provider.WpLogonManager.Action()
at Teradata.Client.Provider.WpSession.ManagerAction(WpMessageManager manager, Stopwatch watch, Int32 connectionTimeout)
at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout)
at Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
at Teradata.Client.Provider.ConnectionPool.CreateConnection(UInt32 timeout)
at Teradata.Client.Provider.ConnectionPool.GetConnectionFromPool(Object owningObject)
at Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr)
at Teradata.Client.Provider.TdConnection.Open()
at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
Error: 0xC0047017 at Stores, SSIS.Pipeline: component "ADO NET Source 1" (9891) failed validation and returned error code 0x80004005.
Error: 0xC004700C at Stores, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Stores: There were errors during task validation.
SSIS package "Import stores.dtsx" finished: Failure.
The program '[6492] Import stores.dtsx: DTS' has exited with code 0 (0x0).

----------------------------------------------------------

Anyone has experienced an error like before? I would appreciate any help coz i could'nt find any documentation in Teradata site for this error explaination.

Best Regards

Onur
1 REPLY
Teradata Employee

Re: SSIS 2008 Vs Teradata Via .NET Driver

I suggest testing the connectivity first using NQuery (Installation Directory\Samples\Bin).

The message truncation issue is caused by a socket failure; usually it means that DBS or OS closed/shutdown the socket connection. I would first check for a firewall.