none
"OLE DB Destination" (4403) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (4416).

    Question

  • I have package which have sequence container and inside that sequence container there is 10 child sequence container each container represents the single table. When I execute that Package to through the SQL Server Job all eight or nine container execute successfully but only one or two container give error which has given below. But when we go to the package and right click on error container and execute them it executes success fully. Please help me to solve this mystery.

    "OLE DB Destination" (4403) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (4416). 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:30:00 AM Finished: 3:01:13 AM Elapsed: 9072.95 seconds. The package execution failed. The step failed.


    Mayank Tripathi Sr Sql Developer

    Sunday, March 30, 2014 3:55 AM

All replies

  • Are you getting any other error messages. The posted error is more generic and may not help much in understanding real issue. can you enable logging or OnError ,OnWarning events and see if you're getting any more information there?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Sunday, March 30, 2014 7:22 AM