qhjghz (1/7/2009)
Hi,I require to do a SFTP through SSIS. I have used WINSCP for this purpose. I have used the command-line utility for WINSCP and am able to upload the file properly. But, I want the path to be uploaded to be a variable one and not a fixed one. Is it possible to pass a user input to the WINSCP command line script? if possible, can anyone please share the script?
In the Execute Process Task, you have to setup SSIS expression for the process argument. You can setup the expressions by right-clicking on the task and selecting Properties. Scroll-down and find Expressions. Setup expression for your argument there.
You may also consider the SFTP Task. It is commercial, but it is much better integrated with SSIS.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
