Failed to export and import data via "Teradata OleLoad"

Database
Enthusiast

Failed to export and import data via "Teradata OleLoad"



Hi everyone,

Could you tell what's wrong with my Teradata server.
I got following error when i want to do import/export data from another Teradata server to my current Teradata server via "Teradata OleLoad"

error message:
Cannot open rowset from command because:[NCR][ODBC Teradata Dirver]Syntax error: Blank name in quotation marks

Following is my hosts file setting on the Teradata server:
127.0.0.1 l ocalhost
10.195.226.5 ASTDcop1
10.193.26.10 TerDcop1
10.193.26.10 TerminalServerName
10.195.226.5 SourceServerName

Could you please help me check what's wrong with my hosts file?

Thanks
Winnie
1 REPLY
Teradata Employee

Re: Failed to export and import data via "Teradata OleLoad"

There is nothing wrong in the Database/Utility.

The procedure for import/Export operation using OleLoad is:
1) select source and make successful connection.
2) select the desired source table.
3) Then select destination database.

Hope you will not get the same error message again.