sapscript in SSIS not working from SQL job

[former_member399259]

I developed a SSIS package with a single Script Task with a sapscript code to do some stuff. From visual studio it works fine. I deployed to a sql server (in my laptop) and then validated and executed succesfully. So far so good. Finally I create a SQL job to run the pacakge and it keeps running with no results until I kill it.

for now sql agent is running under my account

I know this is probably more related to SQL Server but any advice will be much appreciated.

Is there any restriction in the job execution of the package that might be intefering or avoiding exceution?

Visual Studio 2019, sql 2019 (DB and SSIS)

sapgui 760

[former_member399259 · Accepted solution]

Solved. The script was waiting for GuiApp to be "Active" in a loop. For now just replaced with a "sleep" and works.

btw. I created a package parameter "password" and marked as "sensitive", but I need to clear it before deployment or It can be easily recovered using the "Import Project Wizard" from the server.