I've written a data update script that works really well, it deletes a target feature class and uses the feature class to feature class geoprocessing tool to copy data from SQL 2012 into it's predecessors location.
The script works when run via python shell or scheduled via cmd. However our preferred workflow tool uses powershell 2012 (remotely). Invoking-command in powershell for our ArcPy script errors in several places.My main concern is the feature class to feature class tool:
ERROR 000732: Input Features: Dataset \bacon.sde\tasty_Prod.dbo\v_cheese does not exist or is not supported Failed to execute (FeatureClassToFeatureClass).
Why would the feature class to feature class tool work via python shell and cmd and not via powershell?
The same script uses table to table (updating tables) and it works in powershell.. only things that have geometry have issues..