Page 1 of 1
Error in setOutputFieldAsString()
Posted: Mon Mar 28, 2005 3:40 pm
by nghadi
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'.
Posted: Tue Mar 29, 2005 4:39 am
by ray.wurlod
What is field 8? Remember that numbering is zero-based. 0,1,2,3,4,5,6,7
Posted: Tue Mar 29, 2005 4:16 pm
by nghadi
8th field is line_2_addr varchar(50).
Posted: Wed Mar 30, 2005 1:43 am
by ray.wurlod
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.
Posted: Wed Mar 30, 2005 11:54 am
by nghadi
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?
Posted: Wed Mar 30, 2005 11:01 pm
by T42
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?