Not able to export data from SQL Server using TPT ODBC Operator

Tools
M_M
Teradata Employee

Not able to export data from SQL Server using TPT ODBC Operator

Hi TD Experts,

Please help me in identifying the cause for below issue.

I am able to fetch data from the MS SQL Server using Teradata SQL Assistant .

But when I try to fetch the same data using TPT ODBC Operator no data is returned.(Using the same ODBC Connection)

Here's the part of the TPT Script:

DEFINE SCHEMA Test_S

(

"id"                                    INTEGER

);

DEFINE OPERATOR Test_ODBC_OPERATOR

DESCRIPTION 'ODBC OPERATOR to pull data from SQL Server table '

TYPE ODBC

SCHEMA Test_S

ATTRIBUTES

(

VARCHAR PrivateLogName = 'Test_ODBC_OPERATOR_Privlog.log',

VARCHAR DSNName = 'SQLSERVER_PRD_DB',

VARCHAR UserName = 'User',

VARCHAR UserPassword = 'pwd',

VARCHAR ARRAY TraceLevel = [ 'PX', 'OPER','ROW' ],

TruncateData = 'Y' ,

VARCHAR SelectStmt = 'SELECT  id  FROM dbo.table ;' );

The log says:

STATE=S1092, CODE=0,

MSG='[Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier'

5 REPLIES
Teradata Employee

Re: Not able to export data from SQL Server using TPT ODBC Operator

TPT is only certified with ODBC drivers from DataDirect.

You can download a free 15-day evaluation copy.

Try that and see if your job runs successfully.

-- SteveF
M_M
Teradata Employee

Re: Not able to export data from SQL Server using TPT ODBC Operator

Hi Feinholz,

After installing the progress Data Direct ODBC and setting up the connection, I re-ran the script.

I see no data retrieved from the Source Server(MS SQL Server).

TPT fails and only error message that I see is:

TPT17182:Error 8 in creating ColumnNames global memory area.

I have no idea what this error signifies.

Please suggest.

M_M
Teradata Employee

Re: Not able to export data from SQL Server using TPT ODBC Operator

I just realized ...its the issue with the SELECT columnlist. After correcting the SELECT clause I see the job is running fine and is able to export correct no. of rows from source.

However log says, 37 rows exported ans 38 rows inserted.

I have already posted this issue in a separate thread.

http://forums.teradata.com/forum/tools/tpt-odbc-operator-6-rows-exported-from-source-7-rows-loaded-i...

Waiting for your response !

Thanks !

Teradata Employee

Re: Not able to export data from SQL Server using TPT ODBC Operator

Yeah, we know about that row count problem and are still investigating.

-- SteveF

Re: Not able to export data from SQL Server using TPT ODBC Operator

Hi what do u mean of 

" After correcting the SELECT clause "

what changes you applied . Thanks

VARCHAR SelectStmt = 'SELECT  id  FROM dbo.table ;' );