Unrecognized Argument

DSguru2B · Post by **DSguru2B** » Fri Mar 10, 2006 9:55 am

I am loading from SQL server using ODBC EE stage and using it for Change Capture and the job is aborting saying " Unrecognized Argument : &"
I tried loading it into a peak stage using ODBC EE and Dynamic RDBMS stage as well. Straigt loads are working fine.
Any thoughts on this?

ArndW · Post by **ArndW** » Fri Mar 10, 2006 10:02 am

What does your user SQL read?

DSguru2B · Post by **DSguru2B** » Fri Mar 10, 2006 10:10 am

Its nothing big.. A simple select
select * from table where tocurrency='usd'.
The only place where the '&' is present in the password.

DSguru2B · Post by **DSguru2B** » Fri Mar 10, 2006 10:19 am

Got it Andrw. It was my mistake .. thanks anyways

kumar_s · Post by **kumar_s** » Sat Mar 11, 2006 8:08 am

DSguru2B wrote:Got it Andrw. It was my mistake .. thanks anyways

Is it possible to share the root cause, so that atleast fot this thread which will end with an answer.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 11, 2006 8:51 am

My guess is that there was an inadvertent & in the SQL statement.