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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-09-13 : 05:53:55
|
| Hi i have 2 files sitting on a FTP server i need some way of getting these file down to a local server and then add them into my database. any help would be great. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-13 : 05:57:19
|
see here http://www.mindsdoor.net/#FTP
KH |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-13 : 06:23:46
|
| Thanks, can i ask u one quick question, my files are on the FTP in a folder. in this example how do i references the full path name all i have is a folder name "F_files" How do i set the @SourcePath do i just give it the name of the folder folder or will i give it the ftp ip address. The workdir i have the full server name and folder so that should be ok.Will this work ?@SourcePath = \F_files' ,@SourcePath = \\11.11.11.11\F_files\' ,@SourceFile = 'myfile.html' ,@workdir = \\servername\folder\temp\' |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-13 : 07:00:18
|
| I found a very easy way, as my file name is static i could use the FTP that included in the DTS package. no need for the stored procedures.. |
|
|
|
|
|
|
FTP.