Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mhpr
Starting Member
2 Posts |
 Posted - 2008-05-23 : 00:40:52
|
| Hi , Can any one please provide me the steps or proccedures to be follower to SFTP a file from a source system to sql server.thanks in advance.best regards,mhpr |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-23 : 22:30:34
|
| It's not sql issue, just get file with ftp command. |
 |
|
|
mhpr
Starting Member
2 Posts |
Posted - 2008-05-29 : 00:00:22
|
quote:
Originally posted by rmiao
It's not sql issue, just get file with ftp command.
but is need to automate this process.. so that the file comes to the server on weekly basis(on friday). |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-29 : 02:51:48
|
If you want SFTP, try out WinSCP application.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-05-29 : 10:38:01
|
| you can also use the tools provided in the putty package. get it here http://www.chiark.greenend.org.uk/~sgtatham/putty/download.htmlpsftp is the putty version of sftp.-ec |
|
|
|
shobinmathew
Starting Member
16 Posts |
Posted - 2008-06-02 : 06:16:10
|
| you can use a scheduler written in any programming languages |
|
|
|
|
|
|
how to sftp a file in SQL sever 2005