Archives of the TeradataForum

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

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

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>>