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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Creating table with filenames from FTP

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.
Go to Top of Page
   

- Advertisement -