DTS with SSH sftp

[Roland Lee]

Hi all,

I find this in the MS web site:

----
Microsoft SQL Server 2000 introduces several DTS enhancements and new features:

New DTS tasks include the FTP task, the Execute Package task, the Dynamic Properties task, and the Message Queue task.
----

I want to ask, can I use sFTP (bundled with SSH2 server) instead of FTP?

Thanks,
Roland Lee

[Phil Mc]

Under SQL 2000 you can write your own tasks and add them into DTS designer.

If you only use SQL7, then use VBScript and instantiate the DLL from within the VBScript.


------------
Roland Lee at 3/23/01 2:20:48 AM

Hi all,

I find this in the MS web site:

----
Microsoft SQL Server 2000 introduces several DTS enhancements and new features:

New DTS tasks include the FTP task, the Execute Package task, the Dynamic Properties task, and the Message Queue task.
----

I want to ask, can I use sFTP (bundled with SSH2 server) instead of FTP?

Thanks,
Roland Lee