Error message when you try to run an SSIS package in SQL Server 2008: "The package cannot execute because it contains tasks that failed to load"

Article translations Article translations
Article ID: 955646 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to run a SQL Server Integration Services (SSIS) package that contains a script task in Microsoft SQL Server 2008, you may receive an error message that resembles the following:
Error: date_time
Code: 0xC0024107
Source: Fail!
Description: There were errors during task validation.
End Error
Error: date_time
Code: 0xC0010025
Source: name
Description: The package cannot execute because it contains tasks that failed to load.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).

CAUSE

This problem occurs if Microsoft Visual Studio Tools for Applications is not installed.

RESOLUTION

To resolve this issue, install Visual Studio Tools for Applications.

Note Visual Studio Tools for Applications is installed when you install Business Intelligence Development Studio.

MORE INFORMATION

Steps to reproduce the problem

  1. Install SQL Server 2008, including Integration Services.
  2. Create an SSIS package that includes a script task.
  3. Uninstall Visual Studio Tools for Applications.
  4. Use the DTEXEC command to run the SSIS package. You receive the error message that is mentioned in the "Symptoms" section.

REFERENCES

For more information about Visual Studio Tools for Applications, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/vsx2008/products/bb933739.aspx

Properties

Article ID: 955646 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
Keywords: 
sql2008relnoteintegrationservices sql2008relnote kbtshoot kbprb KB955646

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com