Cannot create a task from XML for task type "Microsoft.ScriptTask" from aspnet

Carlos Bustos 6 Reputation points
2021-10-23T16:24:57.487+00:00

Hello, I´m having troubles executing a SSIS package from aspnet but I can execute the same package with success from a console application.

Here is the code I use:

  MyEventListener eventListener = new MyEventListener();  
  string pkgLocation = @"C:\temp\Package.dtsx";  
  Application  app = new Application();  
  Package pkg = app.LoadPackage(pkgLocation, eventListener);  
  DTSExecResult pkgResults = pkg.Execute(null, null, eventListener, null, null);  
  • I have enabled logging in my dtsx package but nothing is logged when I execute from aspnet
  • I´m using Visual Studio 2019 version 16.11.5
  • I tryed running Visual Studio as administrator too
  • I have Microsoft Visual Studio Tools for Application 2019 version 16.0.31110
  • I installed Integration Services from Microsoft Sql 2019 Developer Edition (64 bits)
  • I use .Net Framework 4.7.2
  • OS is Windows 10 Enterprise Version 21H1 (19043.1288) , 64 bits
  • There is no log in Event Viewer

The errors I get:

  • Cannot create a task from XML for task "Script Task", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".
  • Failed to load task "Script Task", type "". The contact information for this task is "".
  • There were errors during task validation.

The "Script Task" inside my dtsx package is empty. I added the "Script Task" to the package just for test.

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,219 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Yijing Sun-MSFT 7,061 Reputation points
    2021-10-25T05:28:33.347+00:00

    Hi @Carlos Bustos ,
    As far as I think,you could try to add SQL Server Integration Services Projects to fix.

    Best regards,
    Yijing Sun


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments