Hi Martin, Can I get the sample data for this? Looks like more than one table is set "IDENTITY_INSERT ON" at the same time.
Best regards, Tamas 2018-05-12 16:10 GMT+02:00 Martin Landa <landa.mar...@gmail.com>: > Hi, > > 2018-05-12 15:51 GMT+02:00 Martin Landa <landa.mar...@gmail.com>: > > > ERROR 1: Failed to set identity insert on layer, [Microsoft][SQL Server > Native C > > lient 11.0][SQL Server]IDENTITY_INSERT is already ON for table > 'kn2.dbo.par'. Ca > > nnot perform SET operation for table 'dbo.bud'.. > > ERROR 1: Unable to write feature 1 from layer BUD. > > ERROR 1: Terminating translation prematurely after failed > > translation of layer BUD (use -skipfailures to skip errors) > > Input DB has about 50 layers, see > > ... > 1: PAR (None) > 2: BUD (None) > 3: ZPOCHN (None) > ... > > It seems that all records from PAR layer are sucessfully writen to > target PAR table in MSSQL. Writing features from second layer (BUD) > fails. No records written. It must be related to BCP. Martin > > -- > Martin Landa > http://geo.fsv.cvut.cz/gwiki/Landa > http://gismentors.cz/mentors/landa > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev