Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
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








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables