Solved

What does this SQL Import Error Message mean?

Posted on 2008-10-27
7
1,462 Views
Last Modified: 2012-05-05
I am importing an Excel file in to SQL 2005 but I am receiving the following error message:

- Copying to [dbo].[table] (Error)
Messages
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: "Unspecified error".
 (SQL Server Import and Export Wizard)
 
Error 0xc020901c: Data Flow Task 1: There was an error with input column "identity" (184) on input "Destination Input" (141). The column status returned was: "The value violated the integrity constraints for the column.".
 (SQL Server Import and Export Wizard)
 
Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "Destination Input" (141)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (141)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - iida_members_update_new" (128) failed with error code 0xC0209029 while processing input "Destination Input" (141). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 

***** There are no duplicates or non int values in the identity column of the excel file.  Where should I look next?
0
Comment
Question by:trumpman
  • 3
  • 3
7 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22813780
My guess is that you're importing data that violates a primary key or a unique constraint....or possible a foreign key constraint.
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22813834

If you are not trying to insert duplicate records check SQL version because "Microsoft SQL Server Native Client 10.0" is the provider for SQL 2008.
0
 

Author Comment

by:trumpman
ID: 22813959
@chapmandew:

How can I check this?

...here is the end of my create table{}...

 CONSTRAINT [PK_mytable] PRIMARY KEY CLUSTERED
(
      [identity] ASC
) ON [PRIMARY]
) ON [PRIMARY]


@PedroCGD:

What do I change it to to reflect the current version?  I have almost fully upgraded to 2008 now.  However, some old dbases are still on 2005.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 22

Expert Comment

by:PedroCGD
ID: 22814133
Try create a new connection to a SQL Native client 9.0 (SQL 2005)
See image
regards
SQL.JPG
0
 

Author Comment

by:trumpman
ID: 22814295
@PedroCGD:

I tried importing a separate table and was successful.  While the provider difference might not be an accepted standard, I do not believe this is causing my error.
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22814372
ok... maybe, but the errro is inserting not reading.
but the error seems that you are trying to insert a forerign key that does not exist in related table...
regards
0
 

Author Comment

by:trumpman
ID: 22814979
@Chapmandew, your original post was correct.  I removed all constraints and noticed that there were four rows at the end of the table after import to SQL with all NULL values.  I went back to the excel file and selected the first four empty rows at the end of the file and deleted them.  Importing the file after this adjustment posted no errors or NULL rows.

- Trumpman
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now