I'm trying to automate uploading a file to a secure FTP site using a
program called WinSCP.

I can run it from the command line using something like:
winscp3 /console /script=example.txt

But I want to call this from the activex task. At the moment DTS tells
me there is a syntax error on this line. I kind of expected this as I
must have to declare WinSCP somehow before DTS will know what it is.

Could someone tell me how to use make this work in the activex script
task? or if there's a better way of connecting to SFTP from DTS?

Thanks
Leslie

The ExecuteProcess task is more suited to this kind of thing can you use
that?


Allan

"les" <les> wrote

Yes I think I can. I just discovered it after posting here.
Thanks Allan

Leslie


On Wed, 2 Nov 2005 20:26:29 +0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:

Make sure you supply unc's or that the exe and any command line
parameters are in the path. One thing that gotten me several times
before is that the default path for an executing dts package is in the
....\binn folder