Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2010-11-10 : 08:57:11
|
| Hello,i am tring to import data from 5 seperate excell documnets with same no_of_columns in to single database table,the first excell document imported sucessfully but when i am importing the 2nd excell document into the database table.its throwing an errorCopying to [EMP_SALARY].[dbo].[DETAILS] (Error)MessagesInformation 0x402090df: Data Flow Task: The final commit for the data insertion has started. (SQL Server Import and Export Wizard) Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'ROW_NUM', table 'EMP_SALARY.dbo.DETAILS'; column does not allow nulls. INSERT fails.". (SQL Server Import and Export Wizard)in all of my excell documents the first column contains ROW_NUM which start from 1 to ni set as promary_key to the row_num column in my database table.already when i imported first excell document the column ROW_NUM was filled upto 1090,when i am trying to import 2nd excell document throwing an error as ther is already row_num,could you please tell how to avoid this issue.Thanx in advance.Satya |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-10 : 09:56:27
|
| Import data to another table and from that table insert into source tableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Error while importing data from excel document