This project is read-only.

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


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
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


mgallen wrote Jan 16, 2014 at 8:59 PM


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.