I have 3 text files that need to be ftp'd from an ftp server nightly, then each uploaded to their own table in SQL Server. Write the code in Cold Fusion 5. The text files are mls properties. Hopefully someone has done it. One file has 175 fields with 20,000 records. the other has 10,000 records, the 3rd has about 1400.
I need to schedule this cold fusion page to run every night. The page should ftp the files down from an ftp site, then import them each into their own table in SQL Server. It has to be done with COld Fusion because the hosting company will not allow me to use DTS in SQL Server.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
cold fusion 5 , windows 2000 server, sql server 2000