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 |
|
j4ydh
Starting Member
18 Posts |
 Posted - 2010-07-29 : 16:59:57
|
| HiI am trying to understand if it is possible to use an sql 2008 job to run a regular script (every 6 hours) that logs into an ftp area and takes the names and lastwrite date of jpg files that exist and then inserts the details (name, date) into a table?In summary its the procedure to access ftp and retrieve file detailsas items are added over time.Is this possible or a sound approach?Thanks in advanceJ |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2010-07-29 : 17:08:44
|
| I think you'd need to creat a dll that actually pulls the ftp info from the ftp and use the sp to call the dll on the job. That sounds like the most efficient way. |
 |
|
|
j4ydh
Starting Member
18 Posts |
Posted - 2010-07-30 : 02:46:10
|
| Thanks,I have read about the dll fuction but also a come across an sp that opens ftp with credentials and pulls the files in as binary.I just want the name and date values to be picked and added to the table over time, so Im thinking it shouldn't be so complex.Still not sure if I am wasting brain power though. A valuable asset to me as it is in short supply and great demand.J |
|
|
|
|
|
|
filenames from ftp then sproc insert