May 20, 2009 at 9:14 am
Hi All,
I am new to SSIS.I want to import the data from textfile in to database tables.I have created a package in SSIS for this.
But I am getting the following error message when i am executing the package,
[OLE DB Database [126]] Error: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "Unspecified error".
[OLE DB Database [126]] Error: There was an error with input column "CurrencyKey" (236)
on input "OLE DB Destination Input" (139).
The column status returned was: "The value violated the integrity constraints for the
column.".
[OLE DB Database [126]] Error: The "input "OLE DB Destination Input" (139)" failed
because error code 0xC020907D occurred, and the error row disposition
on "input "OLE DB Destination Input" (139)" specifies failure on error.
An error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Database" (126)
failed with error code 0xC0209029. 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.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029.
Any help would be greatly appreciated!!
May 20, 2009 at 11:59 am
Could be an error with the data type, a primary key or unique constraint, or a foreign key. Can you provide data types and values?
You may want to check out this article[/url] and if you are using 2005 the article linked in the opening paragraph along with the discussion.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 20, 2009 at 2:14 pm
I checked with the datatypes of the column ,but there is no constraint and there is no primary key.
It datatype is int,not null
May 20, 2009 at 2:41 pm
Odds are you have a value that is not an integer or is out of the range of integer values.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply