Archives of the TeradataForum

Message Posted: Tue, 06 Dec 2005 @ 11:43:02 GMT

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

<-- Anonymously Posted: Monday, December 05, 2005 20:20 -->

This problem does not occur for me. The error message:

Column "p2" does not exist in the destination table.

is indicating that the destination table (actually, in this case it's really the output file, not a table) does not contain a column named p2. Double check that the output file only contains a single line with the column names (in this case, just "p2").

Double check that the .AMJ does accurately specify the output file. Open it with notepad. In the OLE_DB_AXSMOD_Jobs / Job / Destination / PropertySet having a PropertySetId of DBPROPSET_DBINIT, within the Property having a PropertyId of DBPROP_INIT_DATASOURCE, the PropertyValue must contain the name of the folder (in this case "c:\"). And in OLE_DB_AXSMOD_Jobs / Job / Destination / TableName must contain the name of the file (in this case "myoutfile.txt").

If you still cannot get this to work, I suggest opening an incident with the Teradata Global Support Center.

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