Due to a huge project on our contracts I have been asked to update the data on contracts what I am trying to do is insert a load of data into SVC00601
Everything works and the SSIS Package has all Success except for 1...
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'DEX_ROW_ID', table 'SCH.dbo.SVC00601'; column does not allow nulls. INSERT fails.".
(SQL Server Import and Export Wizard)
DEX_ROW_ID is not in my spreadsheet and I have ticket
Enable identity insert
Any ideas how to overcome this?
Many thanks