[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

hi,

i have ssis package , running fine since 1 year. 

it fetches data oracle database , inserting same data sql table. 

somehow transferring 6 rows out of around 2000 rows , giving error mentioned below. 

[ole db source [1]] error: ssis error code dts_e_oledberror.  an ole db error has occurred. error code: 0x80004005.

[ssis.pipeline] error: ssis error code dts_e_primeoutputfailed.  the primeoutput method on component "ole db source" (1) returned error code 0xc0202009.  the component returned failure code when pipeline engine called primeoutput(). meaning of failure code defined component, error fatal , pipeline stopped executing.  there may error messages posted before more information failure.

there 1 warning in beginning of package execution. 

[ssis.pipeline] warning: warning: not open global shared memory communicate performance dll; data flow performance counters not available.  to resolve, run package administrator, or on system's console.

i run package 32 bit machine.

could please advise me error , how resolve it?

thanks in advance.

hariax

---

hariax j. thoria mca

hi hari,

i dont think warning performance dll matters. may check destination server status. it's more error destination server when inserting data. have done change dest server? or dest server in status have enough disk space table?

thanks,

rodge

SQL Server  >  SQL Server Integration Services