I begin to think these tools are buggy:
1. "Table to Table": only returns empty table when input is Table View, although the online document says this tool supports Table View
2. "Make Table View": returns empty table view if the data source is from SQL database. For local file database, this tool works fine
3. "Make Query Table": Does not accept Alias column names at all! It also returns empty table view when many (>15???) columns are involved. I have to remove some columns to get data out from SQL database.
I made the Employee sample works to a point after I struggled with the buggy tools for many days (see attachment). But:
1. I have to use "Copy Rows" in stead of "Table to Table" to save data to a table. "Copy Rows" cuts column name. In the real project, what I get in the output are columns with names like "xxxxxxxxx_1", "xxxxxxxxx_2", "xxxxxxxxx_3", "xxxxxxxxx_4" ... Really annoying! Is there another better tool to use?
2. The "Copy Rows" does not accept "%scratchworkspace%". It uses physical path to save intermediate file. But how can I use this tool on ArcGIS server where many users run this model at the same time?
I am still new to ArcGIS models. The only book that may help me with the ModelBuilder will be published in June this year when my project is scheduled to be finished already &%$&*^&*