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'.
Error in setOutputFieldAsString()
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Check both input and output links to ensure that no non-string data type has been specified.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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?
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?