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.