none
How can I run PowerShell in SSIS with arguements RRS feed

  • Question

  • I am using Visual Studio 2015/SSDT

    In my SSIS pakcage we have used PowerShell scripts that send emails, and those work without issue using Execute Process Task. Although that is only the script, no arguements.  This new PS script uses two arguements, and I'm having issues.

    This script looks in the folder for Arguement 1, and then filenames matching Arguement 2.  It keeps the 5 newest and deletes the rest.  In PowerShell console it runs.  In SSIS it completes sucessfully, but doesn't actually do it's work.



    Any idea what I'm doing wrong?


    -Al H


    • Edited by AlHowarthWF Tuesday, November 19, 2019 2:47 PM typos
    Tuesday, November 19, 2019 2:47 PM

All replies