Hi,
I am investigating the possibility of using FME to convert data
collected on a handheld GPS (Access Database) into the SQL Database
of a Desktop based GIS system. The GIS is for the management of the
road network. At the moment I am trying to import a series of records
for bridge inspections. A table exists in the destiniation dataset
called tbl_mb_Surveys. This structure of this table is as follows:
SurveyID int 4
BridgeID int 4
IMPORTID int 4
Survey_Date varchar 15
Surveyed_By varchar 255
I am able to correctly import all information into the table using
FME Workbench, except for the SurveyID field. This field is the Key
in the table.
I have tried using the statistics calculator to extract the highest
value in the SurveyID field and then the EXPRESSIONEVALUATOR
transformer to add the next integer in sequence, however when I run
the transformation I receive the following error message:
Bulk insert into table 'mb_tbl_Surveys' failed: 'SQL call failed.'
(Vendor Message 1 is: '23000') (Vendor Message 1 is: '[Microsoft]
[ODBC SQL Server Driver][SQL Server]An explicit value for the
identity column in table 'mb_tbl_Surveys' can only be specified when
a column list is used and IDENTITY_INSERT is ON. ** AND ** [Microsoft]
[ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared.')
I've looked at the database writer documentation but cannot find
anything about identity_insert. I'm using FME version FME 2005
(20050805 - Build 1705)
Any help would be greatly appreciated,
Regards,
Helen Divilly, GIS Coordinator, Louth Local Authorities.
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
