Error in setOutputFieldAsString()

nghadi · Post by **nghadi** » Mon Mar 28, 2005 3:40 pm

I'm getting following error when I try to load data from one sql server table to another sql server table. Field 7 is line_1_addr varchar(50). Any ideas why i'm getting this error? Thanks in advance.

Error: Field type must be string in order to call setOutputFieldAsString() for field '7' in output dataset '0'.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 29, 2005 4:39 am

What is field 8? Remember that numbering is zero-based. 0,1,2,3,4,5,6,7

nghadi · Post by **nghadi** » Tue Mar 29, 2005 4:16 pm

8th field is line_2_addr varchar(50).

ray.wurlod · Post by **ray.wurlod** » Wed Mar 30, 2005 1:43 am

In that case it's a bit of a mystery. Can you please post the entire error message (double click the log entry to get detail view)? This will contain the stage and link name where the error was generated.
Check both input and output links to ensure that no non-string data type has been specified.

nghadi · Post by **nghadi** » Wed Mar 30, 2005 11:54 am

Well, I deleted unicode from extended column in column tab and now i'm not getting this error. I don't understand what is unicode and when to use it?

T42 · Post by **T42** » Wed Mar 30, 2005 11:01 pm

Unicode is usually added to your metadata if you have a NLS setup, and does not toggle off the Char -> Unicode option when you import metadata to the job.

Obviously, your SQL server is not NLS enabled. I am not quite sure how to enable it without doing some hard core Googling.

Anyone else know here?