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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-20 : 08:08:14
|
| MH writes "I have multiple FTP sites that will have random files created daily, I need to import only certain file names with the current date timestamp.Is there a custom ActiveX script or Batch file or FTP command that will check time stamp, and file name ie *list*.csv currentdatemy other option is to use a lookup table that contains each file name and a date field that is updated by the export process on the other end, utilizing this table, have DTS lookup fields with the current date, and append those file and server names to the import process to only import current files.Any suggestions or examples are welcome...Thanks aheadM" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-20 : 09:14:58
|
| Look at thesehttp://www.nigelrivett.net/s_ftp_GetDir.htmlhttp://www.nigelrivett.net/s_ftp_PutFile.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Dynamic DTS FTP