locked
sftp source/destination in SSIS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    when are going to have build in sftp source/destination in SSIS?
    it pro
    Tuesday, September 20, 2011 3:57 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi joshi_sgsits_hotmail.com,

    The FTP Task does not support SFTP servers. You will either need to hand-code this yourself using a Script Task, acquire athird party SFTP task for SSIS (I think they're all commercial), or use an Execute Process Task to run a command-line SFTP tool.

    Thanks,
    Sharp

    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Monday, September 26, 2011 8:55 AM
    • Marked as answer by Eileen Zhao Wednesday, September 28, 2011 2:06 AM
    Wednesday, September 21, 2011 9:26 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Good question :) I donot see in Denali as well, may be MS is not interested in providing this much needed and used feature.
    My Blog    |      Ask Me     
    Tuesday, September 20, 2011 5:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi joshi_sgsits_hotmail.com,

    The FTP Task does not support SFTP servers. You will either need to hand-code this yourself using a Script Task, acquire athird party SFTP task for SSIS (I think they're all commercial), or use an Execute Process Task to run a command-line SFTP tool.

    Thanks,
    Sharp

    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Monday, September 26, 2011 8:55 AM
    • Marked as answer by Eileen Zhao Wednesday, September 28, 2011 2:06 AM
    Wednesday, September 21, 2011 9:26 AM