Parse a text file into SQL Server

  • Status Closed
  • Budget $30 - $100 USD
  • Total Bids 13

Project Description

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.

## Deliverables

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.

## Platform

cold fusion 5 , windows 2000 server, sql server 2000

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online