Questions tagged [executeprocesstask]

25 questions
0
votes
0 answers

SQL Server Agent Cannot Run Job With Croatian Characters

I'm trying to run SSIS package with SQL Server Agent Job, but get a fail message. After analyzing I found that the job fails when trying to run Execute Process Task (EPT), which creates a network file path via cmd.exe. The argument in Execute…
0
votes
0 answers

Code: 0xC0029151. The process exit code was "-1073740791" while the expected was "0"

I'm trying to load multiple tables from SQL server to Teradata by launching Fastload through .bat files on Execute Process tasks one by one. If I run the batch files directly, it works. I run the SSIS package, it works. I run the package from…
HarryS
  • 31
  • 1
  • 1
  • 5
0
votes
1 answer

Execute Process Task runs successfully but does not unzip the required .zip file- Visual Studio 2019

When I execute the package, it opens up the 7Zip window. I want that the files are unzipped to the 'WorkingDirectory' New folder. No error is thrown. The 7Zip window opens up and it can be seen that the desired file has NOT been unzipped. I have…
0
votes
1 answer

Shell script execution in ssis

I have a file with extention .sh(shell script). I need execute this file in ssis using execute process task. how can i do this. Please help me!!! Code inside .sh file :echo SSIS test >> /home/junaib/test/sql.txt (for testing)
junaib
  • 21
  • 2
  • 10
0
votes
1 answer

SSIS Execution Process Task StandardErrorVariable property is empty

I have a SSIS Execution Process Task that runs a Powershell script that I'm trying to utilize in the custom logging framework that I'm building. Everything I've researched online has said that if I capture StandardErrorVariable and…
Arthur
  • 23
  • 1
  • 6
0
votes
0 answers

Execute Process Task can't run executable file .bat on Visual Studio 2010 version

I am trying to create a SSIS package using executable file .bat but the Execute Process Task can't run executable file .bat on Visual Studio 2010 version. It's running fine on the previous versions but not on the 2010 versions. Any idea if I need to…
Mohit
  • 9
  • 1
0
votes
0 answers

Can not connect to HBase using Execute script

Get this error when trying to connect to HBase service. I am just trying to implement increment HBase script but can not seem to figure out how to get already functioning HBase connection. Caused by: groovy.lang.MissingMethodException: No signature…
andrew shved
  • 137
  • 1
  • 8
0
votes
1 answer

SSIS: Execute Process Task: How to unzip files in server without any softwares installed?

I need design a SSIS package to unzip files from a folder in Server. The problem is there are no softwares like Winzip or Winrar installed on server. Our IT dept doesn't installation of softwares on server so I am trying to figure out a way to do…
Santosh
  • 23
  • 1
  • 8
-1
votes
1 answer

Batch File Script to split a string into multiple subsisting in SSIS Execute Process Task

I was trying to execute a batch file using SSIS execute process task. This task accepts only one argument. The argument is @[User::TabProjectName]=www.servername Dev_Admin Password123 DENMARK DEV V_Weekly_DEV.This is a space-separated string. How…
user1254579
  • 3,901
  • 21
  • 65
  • 104
-2
votes
1 answer

execute_process at cmake with sed (minGW)

I need to modify a file during cmake execution, working on minGW. This is my code: if(WIN32 OR MINGW) # set Boost_COMPILER to mgw13, to avoid (mgw131, detected mgw13, set Boost_COMPILER to override) error with boost_random message(STATUS…
1
2