June 6, 2012 at 2:52 am
HI,
My pacakge is failing with below error.
"
[OLE DB Destination [258]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description:
"The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005
Description: "Violation of PRIMARY KEY constraint 'PK_USR_STAGING'. Cannot insert duplicate key in object 'dbo.USR_STAGING'.".
[OLE DB Destination [258]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "input "OLE DB Destination Input" (271)" failed because error code 0xC020907B occurred, and the error row disposition on
"input "OLE DB Destination Input" (271)" 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.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB
Destination" (258) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (271).
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.
"
When i ran the package only interger columns are loaded and varchar columns did not loaded i.e Name column ..etc...
when i ran the package to secong time it failed due to Primary KEY issue.
My doute is why it is not loaded the varchar columns(such as name,etc...) i could not see any error about that columns..
Please help me.
June 6, 2012 at 3:52 am
I am using flatfile an oledb components.
we are loading the data form flatfile to table.
We are unable to see the flatfile (source file) data as data is displaying some encypted formated ,.
I am not able to check duplicate values columns on faltfile .....
and another thing,
when i ran same package on JOb and it not loading any thing....
> I have checked and job step and it is created to be executed as an Integration Services package.
>. the job step advanced page - on package failure --- quit with failure,
>.i have added the text file on addvance tab and examined the file after executed,
it shows as
Started: 9:31:53 AM
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 9:31:53 AM
Finished: 9:31:54 AM
Elapsed: 1.312 seconds
Many thanks
June 6, 2012 at 4:36 am
Many thanks.
As you said i have checked and the flatfile was corrupted due to which i am not able see the data present in the flat file.
We have replaced the flatfiles and now able to see the data.
But i am view the all the data present in the flatfile as one column in flat file connection mannager
we are uploading flatfile data to table.
for example:
IN Flat File: Contain data as below.:
TNCI3523 TNEYDO@ticccom TOBY NEYDORFF MUDAILY001 @
IN Flat File CONNction Mannager:
a).faltfile conection Manager Editor-----General---preview---
data is displaying only in col5 and remaining all col as empty
col1 col2 col3 col4 col5(TNCI3523 TNEYDO@ticccom TOBY NEYDORFF MUDAILY001 @}
IN Table we have below columns:
col1(Int) col2(varchar) col3(varchar) col4(char) col5(char) col6(varchar)
My doute is whether Is mY flat file still showing wrongly or is it saved in a wrong format.
can any one plz help me....
June 7, 2012 at 11:22 pm
HI,
CAN ANY ONECHELP ME HERE PLEASE
June 8, 2012 at 12:22 am
bala2 (6/7/2012)
HI,CAN ANY ONECHELP ME HERE PLEASE
Typing in caps equals shouting. It will not get you help any faster.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 8, 2012 at 1:41 am
Stewart, this discussion is continued in another topic:
http://www.sqlservercentral.com/Forums/Topic1312885-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply