WinSCP and SSIS Argument Syntax
I am using WinSCP and SSIS to stage files to a Secure FTP Server. I would like to provide the "Arguments" as a SSIS Variable and am not sure of the syntax.
Something like this...
/script=\\RemoteDirectoryLocation\WinSCP\WinSCPScript.txt /parameter FileName.zip
And the /parameter will correspond to "%1%" in my WinSCPScript
Do I need to enclose the whole thing in quotes within SSIS and the Execute Process Task and the Argument?
I am hoping for a SQL Server SSIS User response for building a WinSCP Argument using SSIS Variables.
Thanks for your review and am hopeful for a reply.
Something like this...
/script=\\RemoteDirectoryLocation\WinSCP\WinSCPScript.txt /parameter FileName.zip
And the /parameter will correspond to "%1%" in my WinSCPScript
Do I need to enclose the whole thing in quotes within SSIS and the Execute Process Task and the Argument?
I am hoping for a SQL Server SSIS User response for building a WinSCP Argument using SSIS Variables.
Thanks for your review and am hopeful for a reply.