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.