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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-12-14 : 15:58:16
|
| is there anyway using bcp/dts to connect to a https server, login, and upload/download files? like ftp, but not same technology as far as i know....... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-14 : 16:51:07
|
| You can run DOS commands using xp_cmdshell. So if you can do it with DOS, then yes.Tara |
 |
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-14 : 17:51:46
|
| anyone know if this can be done using dos or anything else? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-14 : 17:55:42
|
| BCP out the file and write a program that can transfer it over HTTPS that is executed by xp_cmdshell.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-15 : 12:08:38
|
| i have the bcp part working and creating the files. i'd rather not use 3rd party software and not a download management software either. does anyone know how i can connect to https secure site and download/upload files? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-15 : 13:03:36
|
| I think we are telling you that SQL server can't natively do this. You'll need something outside of SQL server to do this. Be it a COM object that's called via sp_OACreate or an EXE that's called via xp_cmdshell, you'll need to have SQL server talk to something outside of SQL server.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
https file transfer