Please be kind. This is my first post and I am new to Powershell. I am executing a Powershell script from my SSIS package by using the Process Task transformation. I am trying to Pass a SSIS variable to Process Task so it will use the variable to download the correct file. The download from a static or hardcoded file name works fine if it is already in the PS script. It fails when I try to pass the variable to the script. Can anyone explain or show me how to pass a variable to a PS script using SSIS? I commented out several attempts with the ## sign.
Thank you in advance very much.
Here is my code: ##ananytics_ndw_DownloadSelectedHistoricWeather.ps1 ## ## File being downloaded is the Historic Weather text file – file format (DS3505) ## This will down load a file that was created by the NCDC (National Climate Data Center) because it was ## manaully requested for a specifc STATE, YEAR on the weather website. ## CLEAR param( [string]SelectedFileName )