I have 8 years worth of polygon data that I'd like to append to 1 feature class in SDE. The source data is from shapefiles.
I've set this up in a single workbench, and pointed all the readers to the same writer. It looked like it would work until I ran it, then I noticed what had happened:
- for each reader, the writer had created a new feature class in the SDE with the name of the writer with a 0 appended to the name, 00 for the next one, 000 for the next one, etc. In the end I had 6 SDE feature classes with names ending in various 0's...
Example: SchoolBoundary_Archive0
SchoolBoundary_Archive0
SchoolBoundary_Archive00
SchoolBoundary_Archive000
SchoolBoundary_Archive0000 etc. etc.
Now I'm guessing this isn't the desired workflow, so I'm wondering what my best course of action would be in order to append this datasets together. Perhaps I should create a seperate workbench file for each?
Any thoughts appreciated.
Thanks!
Matthew Baker
Denver Public Schools