This project is read-only.
2
Vote

This works beautifully when ran from desktop but when scheduled I get errors...

description

Any hints on how to configure when running it on a schedule from the management studio jobs? I have it set up to run and I get the following error:
 
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

comments

mgallen wrote Jan 16, 2014 at 8:59 PM

WORK AROUND:

You are likely running the 64 bit version of DTEXEC if running from the command line. Instead run the 32 bit DTEXEC from C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn.

Works like a charm.