winSCP in SQL server 2005
Greetings!
Up front: I love winSCP... it's an awesome tool.
Now for my current task: I'm trying to script winSCP from within a SQL 2005 SP. Has anyone done or tried this, and if so, pointers, ideas and or directions would be exreamly helpful.
The idea is to pass the SP a table with the commands for winSCP to follow. In this case one could easily create a temp table with what ever is needed (in this case the files to send from within SQL).
Fred
Up front: I love winSCP... it's an awesome tool.
Now for my current task: I'm trying to script winSCP from within a SQL 2005 SP. Has anyone done or tried this, and if so, pointers, ideas and or directions would be exreamly helpful.
The idea is to pass the SP a table with the commands for winSCP to follow. In this case one could easily create a temp table with what ever is needed (in this case the files to send from within SQL).
Fred
