Stack Overflow
Stack Overflow

Questions tagged [executeprocesstask]

25 questions
3
votes
2 answers

SSIS Expression builder for MULTI line file ( Exec Process Task)

My global task to create config file for WinSCP process, and it should be multi lines (no options). I try to use Expression builder for CMD/Echo to do this. And still file, tried all option with and without /C flag which is critical for SSIS cmd…
Mich28
  • 519
  • 3
  • 14
3
votes
1 answer

SSIS - why my process tasks keep ending with result 1 (thus failing SSIS package)

I am trying to move the contents of a folder to another folder. Trying to keep this efficient, I decided to use a Process task: While in SSDT, it works perfectly. But when deployed to SQL Server SSIS on the same machine, it returns PROCESS EXIT 1…
arcee123
  • 101
  • 9
  • 41
  • 118
3
votes
1 answer

Predicting data with Python script in an SSIS package

I'm aware of Microsoft's inclusion of Python in their Machine Learning Services for SQL server, however this is only available for SQL Server 2017 and up, which is a requirement my servers do not currently meet. With that being the case, I wanted…
Dan Scally
  • 1,922
  • 1
  • 19
  • 31
3
votes
1 answer

Release Lock on variables used in Execute Process Task | SSIS

I have a package with a Foreach Container and Execute Process Task inside ForEach Container . On some error in Execute Process Task it redirects to OnError Event handler of ForEach Container. I am capturing the Error from .exe using…
Sai Bhasker Raju
  • 531
  • 1
  • 7
  • 20
3
votes
1 answer

SSIS Run multiple Execute Process tasks in parallel

I have a package that needs to run the separate Execute process task that make command line calls in parallel. I have tested this and SSIS seems to only allow them to execute consecutively (One call waits for the before it finishes despite being…
tbdevmanager
  • 373
  • 5
  • 15
2
votes
0 answers

Limitations with REST API calls using Powershell

I have a need to make a few historical data pulls via REST API call using Powershell. I'm stuck with one of the endpoints where the data volume is over 4 GB. When I run the Powershell script in the Powershell ISE it works as expected. But, When I…
ITHelpGuy
  • 969
  • 1
  • 15
  • 34
2
votes
1 answer

Curl function not working in Apache Nifi using the ExecuteProcess and --data-binary tag

I am having a problem with using the ExecuteProcess with a curl command using the --data-binary tag. When I run this command in the terminal it works: curl https://api.webflow.com/collections/5f7146cacb2fc106ad4c0386/items/ \ -H "Authorization:…
Brian Stitt
  • 21
  • 1
2
votes
1 answer

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. …
David Smith
  • 91
  • 6
2
votes
1 answer

How to pass multiple parameters for executable path in the Process Task (SSIS)?

How to pass multiple parameters for executable path in the Process Task (SSIS)? I will have to pass two Input Parameters. Variable1 = Executable file Variable2 = String Variable as an input for the execution file In the Execute Process Task…
goofyui
  • 3,362
  • 20
  • 72
  • 128
2
votes
1 answer

SSIS Execute process task to copy 2 files into new file

Hi i wanted to copy the records of two csv files into a new file. Task : Copy A + B into C OR Copy A to B ( this is what i am doing but i don't know how via SSIS) I used SSIS to do so using Execute Process Task . In order to verify i tried it in…
user3920526
  • 404
  • 4
  • 20
1
vote
0 answers

How do I use "if __name__ == '__main__':" in an SSIS execute process task?

I have a multiprocessing function that runs fine in Spyder like this: if __name__ == '__main__': global results p = Pool(20) results = p.map(get_api_item, date_list) p.terminate() p.join() When I run that .py file in an Execute…
OverflowingTheGlass
  • 2,324
  • 1
  • 27
  • 75
1
vote
2 answers

How to execute a powershell script in Admin mode via SSIS

I have a powershell script getting all the computers from WSUS using PoshWSUS. I manually execute the script after opening Powershell in admin mode. I have to execute the script using SSIS now. I have inserted Execute Process Task in Control Flow.…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
1
vote
0 answers

Execute Process Task Bpmbs

I have an SSIS package that reads from a spreadsheet and writes out to a CSV file. I also need to have a header record as the first record with the number of records that were processed. I have the 2 data flows to create the output file (,csv) and…
Dick Rosenberg
  • 113
  • 2
  • 10
0
votes
0 answers

SSIS PowerShell Executable not adding Date to the file name

In my SSIS package I’m running a Execute Process Task with the Executable PowerShell.exe. The Arguments is: Get-ChildItem -Path '\servername.com\PRD\SourceFiles' -Depth 6 -Include . -Recurse | Select FullName,Name,LastWriteTime | Export-Csv…
Ern
  • 1
  • 1
0
votes
0 answers

Run boost bootstrap.sh after FetchContent_MakeAvailable(boost)

I'm writing a CMakeLists.txt, and it needs boost library. So I plan to download boost and run bootstrap_sh and b2. But the problem is that it fails every first time I run cmake. After that, it succeeds every time. I don't know why. Below is the…
weareff
  • 1
  • 2
1
2