No results when running powershell script in ssis foreach container

Question

Couple of things to make note of.

Powershell is in unrestricted mode so adding ExecutionPolicy bypass is not needed. Runs successfully when i hard code the variable filename and then set up argument below in Execute Process Task.

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

But once I place that Execute Process task in Foreach loop container, to feed a different filename, nothing happens except the powershell opens and then closes quickly for the number of files in that directory...which suggests it is feeding the variable to the parameter but not actually executing the powershell script with each filename.

Use 4 spaces to format code

Xantium
– Xantium

2018-01-04 20:21:08 +00:00
Commented Jan 4, 2018 at 20:21 — Xantium
– Xantium, Commented Jan 4, 2018 at 20:21

Hadi · Accepted Answer · 2018-01-04 20:37:57Z

1

Check the variable mapping Tab in the foreach loop, it looks like you didn't mapped your variables correctly. Also make sure that you are not selecting the Fully qualified option in retrieve file name Group box. because the expression you are using @[User::Script_url] + " " + @[User::filename] need only to retrieve the Name and extension

answered Jan 4, 2018 at 20:37

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hadi Over a year ago

@missy if this answer solved your issue, you have to accept it, just click on the mark below the voting arrows meta.stackexchange.com/questions/5234/…

Collectives™ on Stack Overflow

No results when running powershell script in ssis foreach container

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related