Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp No SFTP Task Component in SSIS 2005/2008? No Problem! RE: No SFTP Task Component in SSIS 2005/2008? No Problem!

  • May 25, 2011 at 3:02 am

    #1329540

    To avoid logging in once, add registry entry and use a service account.

    Manually add the host key registry entry to [HKEY_USERS\S-1-5-21-3505284427-344095049-820599171-1160\Software\SimonTatham\PuTTY\SshHostKeys] where the SID in this case corresponds to the SQL Server Agent user account.