All Forums Tools
M.M@TD 16 posts Joined 03/13
06 Nov 2013
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'

 
 
 

feinholz 1234 posts Joined 05/08
07 Nov 2013

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@TD 16 posts Joined 03/13
07 Nov 2013

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@TD 16 posts Joined 03/13
07 Nov 2013

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-into-teradata-weird
Waiting for your response !
Thanks !
 
 

feinholz 1234 posts Joined 05/08
07 Nov 2013

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

--SteveF

capisfr 1 post Joined 08/12
20 May 2015

Hi what do u mean of 
 
" After correcting the SELECT clause "
what changes you applied . Thanks
VARCHAR SelectStmt = 'SELECT  id  FROM dbo.table ;' );

You must sign in to leave a comment.