No results when running powershell script in ssis foreach container

A few things to note.

Powershell is in unlimited mode, so ExecutionPolicyno bypass is required. It succeeds when I hardcode the variable file name and then configure the argument below to Execute Process Task.

@[User::Script_url] + " " + @[User::filename] 

But as soon as I put this Execute Process Taskin Foreach loop containerto give a different file name, nothing happens, except that powershell opens and then quickly closes for the number of files in this directory ... which suggests that it loads the variable to the parameter, but doesn't actually execute powershell script with every file name.

+4
source share
1 answer

foreach, , . , Fully qualified " ". , @[User::Script_url] + " " + @[User::filename], Name and extension

enter image description here

+1

Source: https://habr.com/ru/post/1691758/


All Articles