question

CarlosBustos-5938 avatar image
0 Votes"
CarlosBustos-5938 asked YijingSun-MSFT answered

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

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.




sql-server-integration-servicesdotnet-aspnet-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YijingSun-MSFT avatar image
0 Votes"
YijingSun-MSFT answered

Hi @CarlosBustos-5938 ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.