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.
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
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.