Closed

File Import and Database Insert / Export

This project received 22 bids from talented freelancers with an average bid price of $539 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
22
Project Description

I need a .Net v2.0 [url removed, login to view] app that uses SQL Server database and SSRS Reports.

I am looking to take a tab-delimited file, importing it using this new app, and break the data out into separate tables, and build a report out of it's contents, complete with sort options, searching through the imported records.

I have an excel spreadsheet that includes all of the master table value information as well as sample data, file layout specs, etc.

A few fields (Columns) of data include multiple value separators, including ~ and |, that need to be separated out and delimited by ,'s.

If a row cannot be imported, we need to know what is messing up the file at the row level and if possible, the column level.

After this data has been entered into the SQL warehouse you create with a column value for a practice (and maintaining perfect referential integrity), it needs to be able to export into three separate txt files, tab delimited.

Option to catch exceptions and edit on the fly must be possible.

Sample files will be provided.

Specs will be provided.

Delivery must include:

SQL database objects, including tables, SPs, and any other objects suitable in a SQL 2005 environment.

SSRS report that has query fields, etc., for drilling down on various types of referential data, groupings, etc.

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