x
login about faq Site discussion (meta-askssc)

SSIS package fail

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

more ▼

asked Nov 09 '11 at 06:25 AM in Default

zain001 gravatar image

zain001
61 6 7 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Nov 09 '11 at 10:52 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
20.3k 5 10 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x749

asked: Nov 09 '11 at 06:25 AM

Seen: 690 times

Last Updated: Nov 09 '11 at 06:25 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.