Error: 2011-11-07 21:09:05.78 Code: 0xC004706C Source: Load T105 Unit 0 SSIS.Pipeline Description: Component "component "WorkUnit 0" (1)" could not be created and returned error code 0x800703FA. Make sure that the component is registered correctly. End Error Error: 2011-11-07 21:09:05.78 Code: 0xC0047036 Source: Load T105 Unit 0 SSIS.Pipeline Description: component "WorkUnit 0" (1) failed initialization and returned error code 0x800703FA. End Error Error: 2011-11-07 21:09:05.78 Code: 0xC0024107 Source: Load T105 Unit 0 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:00:07 PM Finished: 9:09:05 PM Elapsed: 11338.3 seconds
asked Nov 09 '11 at 06:25 AM in Default
Does the package use some kind of custom component?
From the error it seems so.. If the package uses a custom component, then you have to install that component on the machine on which the SSIS package is being executed.
Another possibility is that some of the core SSIS components is corrupted and you will have to reinstall the SSIS on the machine.
Another possibility (but not sure if this can cause this error) could be that the package is using some components available only in Enterprise edition of SQL server, but is executed on Standart edition - but as I wrote, I'm not sure by this and don't have a possibility to test this scenario now.
answered Nov 09 '11 at 10:52 AM