What does this SQL Import Error Message mean?

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?
trumpmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chapmandewConnect With a Mentor Commented:
My guess is that you're importing data that violates a primary key or a unique constraint....or possible a foreign key constraint.
0
 
PedroCGDCommented:

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
 
trumpmanAuthor Commented:
@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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
PedroCGDCommented:
Try create a new connection to a SQL Native client 9.0 (SQL 2005)
See image
regards
SQL.JPG
0
 
trumpmanAuthor Commented:
@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
 
PedroCGDCommented:
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
 
trumpmanAuthor Commented:
@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
All Courses

From novice to tech pro — start learning today.