I need to load in data from a mortgage company each month. Each text file has 12-14 million records each month. I need to use a DTS package or whatever is recommended to load the data each month into the SQL Server into a table for each month. I will need to run queries against the data, so performance is a key componenet to this project. I need all fields to be setup according to the attached file layout. Most of the fields have financial data, so the fields need to allow for caculations.
## Deliverables
1) Complete and fully-functional working SQL Scripts or DTS packet or whatever format is recommended to load the data into the SQL Server. The script must load the data into the most efficient format possible.
2) Deliverables must be in ready-to-run condition.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2003 Server
SQL Server 2000 with Service Pack 3