Im pretty new to the DTS functionality of ms sql server. I noticed that it has the ability to ftp stuff. Well, I was wondering if it has the ability to use secure ftp? I havent found a 'Secure FTP' task and didn't find any secure properties in the standard 'ftp task.' I figure you could create an 'ActiveX Script' task and mabey do it that but, you would probably need an external secure ftp object registered on the machine, im not sure this would work. Any ideas on how I can use secure ftp as part of a dts operation?

Eric