Currently, I'm trying to call a python exe. file and pass the parameters to it from an SSIS package. When I run the package from Visual Studio it does it intended purpose, but when I deploy it to the database although its running nothing happens.
The exe file only opens a command prompt.
Trying to figure out the issue
Since you specified the full file path in the Executable property, you don't have to pass any value in the working directory property (leave it empty) or remove the following string from executable property:
In addition, check the the SQL user running the package has a permission to access the path specified and since you are executing cmd check that you are not using a SQL Service account because it may be unable to execute cmd correctly. Try using Windows login instead.