Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Nov 2012 @ 14:27:54 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: A TPT with Load operator
 
From:   Geoffrey Rommel

There are two problems here.

     VARCHAR FileName = 'C:\JPARK\Teradata\TPT_Scripts\testdata.txt',

Let's assume that this file name is correct and that it points to a file on your workstation. In that case, it will only work if you are running tbuild from your desktop. If you are running from an ETL server, the C drive will be different.

More seriously, the schema for your input file:

     ( Emp_ID         Integer,
       Emp_Name       Char(10)

is incorrect. INTEGER can only be used when the input is a binary integer (32 bits), but your input is a text file. You need to define both input fields as varchar. Then, in the DataConnector operator, the file format is 'Vartext' (not 'Formatted') and the delimiter is ',' (the default is '|').



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023