How about creating a SQL Job that is scheduled to run every 30min. Then all you will need to do is drop the file into a shared folder and the SSIS package will pick it up and ingest it?
The ultimate use of SSIS is to automate things. If in the whole pipeline you are doing things manually it defeats the purpose.
Any chance the SIS owners can create some automation that creates the csv file for you and dumps to your systems as as ftp location?