Skip to main content
  • EN

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


Community Stats

30,108
Posts
114,294
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.