FTP 'SITE' command in SSIS FTP task
I'm using an FTP task in an SSIS package to (you'll never guess) send a file. I need to use the FTP SITE command, in this context:quote SITE standard=nonequote SITE parm=sa=abc123;ra=def456I don't see a way to use SITE in an FTP task. Is there a built-in way to do this? If not, any suggestions?Thanks,Paul
September 17th, 2008 7:01pm
Any clue on how to execute the "QUOTE SITE" command using an FTP task? If not, can we use the API to do the same?
Free Windows Admin Tool Kit Click here and download it now
December 22nd, 2010 3:44pm
Instead, why not to use a Script Task? Or Execute Process Task that will run a batch command with the FTP set the way you need?Arthur My Blog
December 22nd, 2010 4:34pm
Any clue on how to execute the "QUOTE SITE" command using an FTP task? If not, can we use the API to do the same?
No way. The standard FTP Task / Connection Manager doesn't allow direct access to the FTP channel. You may have to implement a script just like what Arhur suggested.
Can you elaborate what is the purpose of this command and why do you want to use it?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2010 5:48pm