SQL Query

What does your log file say? Also, your first line has an equals expression in the SELECT. This should be part of the WHERE?

I don’t think the join to the sde column registry is required, since you’re already dynamically providing the database, owner, table, column name. Unless you’re using the inner join to ensure that the column is strictly in SDE, and not some column from any table.

One other thing you can do is put your SQL construction into an attributecreator, run it, then copy the statement into SSMS to test run it there and have it check your syntax.

Something like this should be all you need?

SELECT
 @Value(column_name) as ResultColumn
FROM
 @Value(datebase_name).@Value(owner).@Value(table_name)
WHERE
 OBJECTID = 1

or even SELECT TOP (1) instead of getting the first row.

In the results, I do get the dates returned from the date attribute.  However, there is no database name, username or table name associated with them because that cannot be captured from the contents of the data tables.  Those fields show up empty.  It isn’t the first part of the query that is a problem, it is the second part.

However, both suggestions are useful, and I will try them both.

Sheila

I solved my problem by changing a parameter value in the SQL Executor transformer.

Thank you for your help.  I did use the SELECT TOP(1) in my query.