x

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, 2011 at 06:25 AM in Default

zain001 gravatar image

zain001
61 7 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, 2011 at 10:52 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x937

asked: Nov 09, 2011 at 06:25 AM

Seen: 1482 times

Last Updated: Nov 09, 2011 at 06:25 AM