I need to be able to automatically import a text file into SQL Server 2000 from an FTP location. This must be automatically executed on a daily basis (say 3am for example) so I assume the best method to use would be a DTS package. Each file that is imported (as a new table) should replace the previous table. The text filename source is always constant. To summarize:
-source of [url removed, login to view] file is my ftp location
-import [url removed, login to view] into SQL and becomes a table named 'myfile' by default (replaces the previous day table)
1) Complete script or directions that will 100% work (try it yourself first with some made up data first
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
SQL Server 2000