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 |
simplymidori
Starting Member
9 Posts |
Posted - 2008-06-06 : 08:20:08
|
Hi, I have a list of filenames,pathway,date, & size in an FTP folder called spotviewer. I normally would have to manually create a DIR file under command prompt then save it as a txt file to import into SQL.Is there a way in SQL to create a stored procedure or another command to get these filenames and update my table from the ftp server?Thanks in advance. |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 00:22:49
|
You can put commands ran under dos prompt in batch file and call it with xp_cmdshell in sp. |
 |
|
|
|
|