Execute Powershell script from SSIS using UNC Path

  • I suspect some type of permissions issue is causing the script to fail.  You might have better luck using a Script Component and PowerShellInstance.  This article outlines how to implement and use this: https://blogs.msdn.microsoft.com/kebab/2014/04/28/executing-powershell-scripts-from-c/

    If your script is only moving/copying files - then I wouldn't even utilize powershell for that.  I would do that in a script component directly.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • The script also downloads some json files from a webservice. That line was just the first step of archiving the objects before downloading new ones. I'll keep that in my back pocket, but the script and the files that being moved are in the same fileshare, so it seems like permissions shouldn't be an issue. And from that same server I do execute batch files on a UNC share using the same execute process tasks. There appears to just be something unique about executing powershell in this way.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply