Skip to main content

Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".

Thanks.

try the featureHolder transformer before writing to your dataset.


Awesome! This works like a charm.


Reply