I am trying to get SSH working in SSIS. Has anyone downloaded this component for SSH and been able to get it to work on a scheduled basis? http://ssissshcomponents.codeplex.com/ I need to connect via ssh and have created a simple .dtsx file to connect and get a file. It works great from my machine, and works great when our admin logs into the sql server and runs it, but when it is scheduled to run, it gives the following error: the connection type "SSH" specified for connection manager "name" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error Error: 2011-04-19 11:00:02.96 I have rebooted the server but still won't work. Any advice would be appreciated...thx

Scheduled to run under SQL Agent you meant, did you? It is a security related issue not even a component one. If it is the Agent, use a Domain account based proxy to run and if it is just a scheduled job, then execute it under whatever account that makes sense (the account with the proper privileges).Arthur My Blog

Can you give me an example? It is the sql server agent job, how would my admin need to set it up?

See How to Schedule and Run a SSIS package ( DTS ) Job article: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx Arthur My Blog

Arthur, below is an email from our network admin (he isn't a sql admin). It still isn't working when it is scheduled but will run when manually kicked off. Could it be the subsystem assigned is not correct? Steps I've done: Created a local user account (later added it to the administrators group because configurations weren't working) Created that account in the Logins section and gave it the same rights to the databases as you (later gave it sysadmin rights) Created an SQL Agent Proxy credential Under the SSIS Package Execution I created a new proxy Proxy Name: SQL Agent Proxy Credential name: SQL Agent Proxy Subsystem assigned is: SQL Server Integration Services Package I try and assign a Principals by clicking Add - your username appears - I select it and click OK and it closes - reopen it and you're not there References under the SQL Agent Proxy is Job Name: CDS_SSH Went into the CDS_SSH job The owner is assigned as you Went into the Job Properties for CDS_SSH Click on the Steps option Double Click on Step 1 of the Job step list - which is Get file from CDS Changed the Run as: SQL Agent Proxy Clicked OK Tried to run it and I get this error message Error: 2011-04-28 07:48:45.95 Code: 0xC0014005 Source: Description: The connection type "SSH" specified for connection manager "name" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error The job failed: The Job was invoked by User EMP\mdutiel The last step to run was step 1 (Get file from CDS) Executed as user: ENTP12\SQLAgentProxy - this is the right user to run it by so that much is certain I believe the error is with SQL Agent Proxy under the SSIS package Execution under Proxies. Because I can't get your name to stay added, the job isn't being submitted/running by you

Instead of the local account you should have used a domain account. Arthur My Blog