An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
I am trying to do a join of a csv and a SQL table. I have both sources inputing into a tMap. I want to join the csv with the SQL table based on a text column in the SQL table. Normally this column is unique, but even if it does not happen to be unique, I only need the first row returned. However I keep getting the error mentioned in the subject. What am I doing wrong?
Thanks that was the issue. When adding the TMSSqlInput auto generated the SQL query with database context variables concatenated in the query. I removed all the context variables and had a single SQL query string and that worked.
This is the query that gets auto generated (which was causing the issue). What is the proper way to concatenate the query with the context variables. Btw the context variable context.netZcore_Schema is defined.
"SELECT \""+context.netZcore_Schema+"\".Plans.CODE, \""+context.netZcore_Schema+"\".Plans.DSCR" +" FROM \""+context.netZcore_Schema+"\".Plans"
