Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

error while running job

hi,
when i am mapping some columns from source to target lets say 20 i get this error below
but if i just map 10 they good looks like data issue any idea who can i get rid of this error

Unable to execute query: SQL passthru expression contained these errors: NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended....  ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER....  NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended....  ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE....  NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended....  NOTE 49-169: The meaning of an identifier after a quoted string may cha
ASKER CERTIFIED SOLUTION
Avatar of d507201
d507201
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aloysius Low
like what d507201 said, please post the full log. in fact i'd go a step further to ask for the code as well.