Hi, I am trying to import a excel file and update a table in the database using a simple SSIS package. I get this error and only 300 rows out of 750 rows were updated in the table. "[OLE DB Destination ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (27)" failed because error code 0xC020907B occurred"
You get this error because of any one of the following reasons
You have a Primary key on a column of the SQL table and you are trying to insert a duplicate value into it.
The rows (data) of the excel sheet may contain NULL values.
The column for which Primary key is specified in SQL table may contain NULL or Duplicate values.
If you fix the above problems you can eliminate the error.
edit | flag
Gokul A Answered on: Jul 06, 2011 at 7:30PM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!