Completed

Import 4-5 CSV Files into a SQL Table - Daily - Send report by email

This project was successfully completed by marasinghe82 for $111 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30-$250 USD
Completed In
3 days
Total Bids
33
Project Description

PLATFORM:
* SQL SERVER 2012
* WINDOWS 2012 SERVER

1. Import all 4-5 CSV Files into 4-5 tables
Import will do the following:
a. import new records
b. update existing record if change is found
c. update record with "not available" if record not found
d. datestamp any records that require update, new, any type of change

You will then generate a report with the following:
• Records # added,
• # deleted,
• # updated,
• what csv file (single family, condo, rental, highrise, midrise, multi-family)
• update that information into a table called “ImportReport”
• create a email using db agent and send out that information on every import

Report will:
* we will run this import every hour
• we will run this import on an increment csvfile that is generated using our secondary software. I will show you how this system works to generate the csv file and increment file.

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