|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/9/2009 6:55:29 AM
Posts: 1,
Visits: 3
|
|
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
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/16/2009 3:03:20 PM
Posts: 152,
Visits: 454
|
|
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.
--Cal
|
|
|
|