Hi All ,
I m trying to connect to TERADATA server from SSIS using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.
Test connection failed because of an error in initializing the provider.[.Net data provider for teradata] can not create the connection wiyhin the time specified.
I have googled a lot but did not find any correct solution.I m struggling from last 2 days. Could you please help me in this.
I tried by changing the timeout property from default value 20 to 200 .After that i m getting the below error.
Test connection failed because of an error in initializing provide.[.NET Data Provider for Teradata] Could not resolve Data Source=172.28.130.20 to an available node after 1 attempts.
[socket transport] System.Net.Sockets.Socketexception(0x80004005):A connection attempt failed because the connected party did not properly respond after a period of time,or established connection failed because connected host failed to respond 172.28.130.20:1025 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List'1 sockets,UtlStopwatchWrapper timer,Int32 timeout,int32 IccTimeout.TdErrorCollection errors)
Please provide solution..
- Edited by Thiru G 12 minutes ago