I've seen the SE_Toolkit mentioned before in the forums, but never tried it out, so now seems like as good a time as any for giving it some love.

I do a few data type conversions and conditional statements using SSIS, so I'm not sure if asc2sde will do all I need it to or not, but I'll give it a try. Your admonition on origin offsets is a good one though, so I'll be sure to include that as well. My ArcSDE is at 9.3.1 SP1 as well, so I'll get that up to SP2 and see if the combination of upgrades makes anything smoother.Ĭoordinates are all well within the defined space, with a few whacky rows where the lat/long is null in the data so I default to 0,0.

I'm pretty sure I've got SS 2008 SP1, but I've asked my DBA to see about getting upgraded to R2 SP1. I have seen things go missing when IDs aren't unique and that is what I expected would happen if the IDs weren't being managed properly, but given I could see the features OK, I couldn't figure out what else would cause the fatal just when doing a select. My test data is only a few hundred rows so it's easy to see the Identity is working as it should. I suspect problems with RowID, but not sure what would be the issue. However, if I try to select any of the features, whether by clicking in the Attribute table, selecting with a rectangle, or by SQL query, ArcMap 'encounters a serious error' and goes away. If I open the attribute table I am able to view all of the data very nicely. When viewed in ArcMap the layer looks fine, and zoom/pan works great. Two of the columns are Latitude and Longitude, and last step in the SSIS import is to generate point geometry from these two columns and write to Shape column (of type geometry) using STPointFromText(). Sdelayer -o register -l onecalls,shape -e np -C onecalls_id,USER -i devdb -u xxxx -p xxxx -x -180,-90,1000000 -G 4326 -t GEOMETRYĭata gets pulled via FTP fine, SSIS is used to read resulting flat file and load data into a table. Registration is handled with this command: The layer is registered with USER maintained RowID column defined as INT NOT NULL IDENTITY. I'm trying to schedule a weekly batch job that pulls a flat file via FTP from a third-party and loads it into an SDE layer. ArcSDE 9.3.1 - three tier for admin, two tier for user access

Ssis row is missing in flat file