SQLServerWiki

“The Only Thing That Is Constant Is Change”

Misguiding Error in SSIS job or package while executing.

Posted by database-wiki on July 9, 2012

Failure of SSIS job with the below error means your SSIS and share components is corrupt

and you need to repair SSIS along with share components to success to get rid of the below error message.

Date                      6/6/2012 10:00:00 AM

Log                         Job History (Generate and Mail TAT Reports)

Step ID                 1

Server                   FL1M-CPT-DB01V

Job Name                            Generate and Mail TAT Reports

Step Name                         Generate and Mail TAT Reports

Duration                              00:00:22

Sql Severity                        0

Sql Message ID                 0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted                          0

Message

Microsoft (R) SQL Server Execute Package Utility

Version 10.50.1600.1 for 32-bit

Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started:  10:00:00 AM

Error: 2012-06-06 10:00:21.91

Code: 0xC00291B1

Source: ActiveX Script Task  undefined ActiveX Script Task

Description: User script threw an exception: “An error occurred while creating the ActiveX scripting host. Verify that the scripting host is installed properly.”.

End Error

Error: 2012-06-06 10:00:21.91

Code: 0xC0024107

Source: ActiveX Script Task  undefined

Description: There were errors during task validation.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started:  10:00:00 AM

Finished: 10:00:21 AM

Elapsed:  21.094 seconds

More Information

TITLE: Package Validation Error

——————————

Package Validation Error

——————————

ADDITIONAL INFORMATION:

Error at ActiveX Script Task  undefined [ActiveX Script Task]: User script threw an exception: “An error occurred while creating the ActiveX scripting host. Verify that the scripting host is installed properly.”.

Error at ActiveX Script Task  undefined: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

——————————

BUTTONS:

OK

——————————

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: