Data not loading into flat file using execute process task

bk 466

Hi All,
I am using a execute task process to execute a .cmd file. The jjob doesnt fail. It runs for 2 mins , but the file gets updated with a recent time stamp, but size of the file is 0kb. There is data in the source file.
Please advice.
Thanks

Yitzhak Khabinsky 25,851 Reputation points

2020-10-26T19:27:13.16+00:00

Please edit your original post and provide more details on what your .cmd file is doing, share its source code, desired output, etc.
bk 466 Reputation points

2020-10-27T12:52:44.77+00:00

Thanks. It is a .cmd file and that file calls a .ps script, which in turn loads the data into this flat file.
bk 466 Reputation points

2020-10-27T13:14:12.393+00:00

cmd.exe file
G:\Extracts\PowerShell_Scripts>powershell "& ""G:\Extracts\PowerShell_Scripts\Email.ps1"""
Cant post the ps1 script as it contains sensitive data.That exact script runs fine on a different server.
Thanks

1 answer

Monalv-MSFT 5,896 Reputation points

2020-10-27T06:49:10.857+00:00

Hi @bk ,

May I know if you change the file name and if you write the cmd correctly?

Please refer to the following links:

Execute Process Task

Executing Command Prompt commands in SSIS

SSIS - How To Execute Batch File By Using SSIS Package

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
bk 466 Reputation points

2020-10-27T12:51:42.56+00:00

Thanks Monalv i tried those links to each step. I tried running power shell script instead and i am getting the following error message
[Execute Process Task] Error: In Executing "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-ExecutionPolicy ByPass -File G:\Extracts\PowerShell_Scripts Email.ps1" at "", The process exit code was "-196608" while the expected was "0".

Monalv-MSFT 5,896 Reputation points

2020-10-30T09:35:31.927+00:00

Hi @bk ,

Hope the following link will be helpful:

Powershell returns negative exit code while script results are correct

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet.

bk 466 Reputation points

2020-11-17T15:19:37.88+00:00

Thanks Mona, unfortunately no , it did not.

Monalv-MSFT 5,896 Reputation points

2020-11-18T06:01:50.137+00:00

Hi @bk ,

Executing "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-ExecutionPolicy ByPass -File G:\Extracts\PowerShell_Scripts Email.ps1"

May I know if you can run the script above successfully in the command prompt?

Best Regards,
Mona
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Data not loading into flat file using execute process task

1 answer

Your answer