%s warning

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Mar 06, 2007 12:53 pm

Hi when i am doing a lookup (decimal to decimal as keys) i get the following warning and no rows are returned.

<Job Name>..Transformer_37: %s

Anyone ever faced this?

DSguru2B · Post by **DSguru2B** » Tue Mar 06, 2007 1:03 pm

Never saw it, change it to varchar and see if the warning remains.

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Mar 06, 2007 1:05 pm

The SQL definition was different from the listed columns. (i copied this stage from someplace which was using a custom SQL).

Changing the options to auto-column generated SQL solved the issue

kduke · Post by **kduke** » Tue Mar 06, 2007 7:55 pm

If you look in the log file they do not store job name. They create place holders for it with %s and I think %1 and %2. I think that is so that you can rename the job easily.