In the Microsoft Tech community, there is a feature request to add support for Python as an Excel scripting language : python for excel application scripting - Microsoft Tech Community - 66113[^]

Using nSofts (S)FTP adapter gave me the opportunity to passing the FTP commands since another delimiter (new line) is used over here : http://www.nsoftware.com/products/biztalk/ http://www.nsoftware.com/products/biztalk/adapters/ftps.aspx

I am currently running into an issue with the BizTalk FTP command delimiter ( ; ) while trying to issue FTP commands using the 'Before Put' field in the configuration of an FTP send port. These are the details : In one FTP command (which has been passed to us by our VAN/FTP provider ) I wish to set the value of parameters (sa and ra) as follows : site parm=sa=:XXXXXXXXXX;ra=:YYYYYYYYYY The semicolon ( ; ) in front of 'ra=:' causes the trouble : this semicolon is being interpreted by BizTalk as a delimiter for FTP commands and as a result Biztalk sends the above mentioned command as 2 separate commands (instead of sending it as one singel command). Do you know of a work-around that can be used in order to circumvent this delimiter issue (an escape character to use, some kind of FTP verbatim notation, ...) ?