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 |
|
sand-lakes1
Starting Member
29 Posts |
 Posted - 2001-04-25 : 12:56:32
|
| Hi,Right now we are using dts in order to import txt.files generated out of an oracle database. These txt.files are the main loads for existing sql server objects/tables. Steps to be taken:* connect to ftp site with files on it* copy these files to a file server* load within existing objects/tables ****if these files have a younger date then the last used files.Is there a possibility/tool which tells sql server that the file on the file-server/ftp-server is younger then the last used files -> start dts package ??You see quite simple: DTS PACKAGE is only allowed to start when a new file has been placed on the server (file name off course stays the same).Thanks for the help/hints/tricks in advanceJohnno |
|
|
|
|
|
Date dependend dts package(s)