DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
smartstream 11/5/2014 3:25:25 PM

Using SSIS to import Data

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

Version: GP 2013
Section: Dynamics GP, SQL Scripts