CODEWITHSUNDEEP
pythonsql-serverssisetlexecuteprocesstask
David Smith
David Smith

Reputation: 91

Passing parameters to exe. file from SSIS

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.

SSIS PACKAGE

The exe file only opens a command prompt.

enter image description here

Upvotes: 2

Views: 1144

Answers (1)

Hadi
Hadi

Reputation: 37313

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:

E:\BOJ\PrimeBOJReport\generatePrimeReportMain

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.

Upvotes: 0

Related Questions