Latest Contributions by City_of_RockfordIL

Hello. Your workflow should work just fine. One thing I would recommend is setting up OLE DB Connections in ArcCatalog for your SQL Server connections. Define the Provider as SQL server and then select your server name, credentials, and database you are reading data from in your script. For your workflow you should be able to simply Make XY event layer from your SQL table (e.g. name it "SQL_XY")and then use the Copy features GP tool. The input features for the tool would be your new "SQL_XY" table and the output feature class would be the SDE feature class you want to export the data to (just ensure that you have also setup a spatial database connection in Catalog to the SDE database) . See attached code and ModelBuilder workflow for an example. Good luck! Tara ... View more