In Progress

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

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.

Here is sample of CSV text file we need to import. 5 total files into 5 tables

Skills: Database Administration, Software Architecture, SQL, Windows Server

See more: what is a condo, hour change 2012, architecture of email system, sql import, multi agent, import csv, highrise, update sql file, create sql report, csv import sql server, csv update, table csv, create tables sql 2012, email daily report, email agent, csv table, update sql server file, sql create report, sql file csv, import csv update records, create table sql server using, sql server update file, csv generate, update sql table csv, report sql server

About the Employer:
( 65 reviews ) Houston, United States

Project ID: #5377300

Awarded to:

marasinghe82

Dear Sir Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, More

$111 USD in 3 days
(46 Reviews)
5.2

30 freelancers are bidding on average $195 for this job

helmot

I have +10 years of experience in programming. What you want is an easy task and can be done in a few days. Also there is no problem in generating report table and also email that. So please let me know if you have More

$170 USD in 3 days
(36 Reviews)
6.1
expertcoder1vw

I'm an expert SQL Server / database / Windows application developer and can deliver an excellent software to do this for you. I can deliver a high performance, software with attractive GUI and logging capability, withi More

$250 USD in 2 days
(46 Reviews)
5.7
urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks More

$206 USD in 3 days
(65 Reviews)
5.5
mihaibejenariu

Dear sir, This is Mihai and I'm interested to work with you on this assignment. I have over 15 years’ experience with SQL Server 2000|2005|2008R2|2012, database design, T-SQL development, performance tuning, replic More

$168 USD in 7 days
(82 Reviews)
5.3
elboukharimu

Aucune proposition n'a encore été fournie.

$231 USD in 7 days
(27 Reviews)
5.1
schungur

DATABASE EXPERT... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Please note that I have SQL level 3 badge.... there are only 4 of these on Freelancer.. More

$166 USD in 3 days
(17 Reviews)
4.9
habibjanjua

Dear Sir, You didn't mention SQL Server 2012 edition in your bid, if you have enterprise edition then change tracking feature will help a lot, but if you do have enterprise edition then I can help you a lot :) Pl More

$250 USD in 7 days
(22 Reviews)
4.8
sunshinelabs

I've built many systems that do similar. It costs more, but you're asking a lot. I am American, live in NYC, have a BS and a day job; I need extra projects this month. I am free to talk on the phone as well anytime. More

$555 USD in 3 days
(10 Reviews)
4.1
anuyadav1

i can make this crop app for your server. .

$200 USD in 3 days
(8 Reviews)
3.7
CARLOSHUGGINS

Hi as a 12 year experienced developer I will deliver a high quality solution meeting all your requirements, are you expecting a desktop app for this task to be done?? Please visit my profile and have a look at what More

$195 USD in 4 days
(5 Reviews)
3.5
workbeezcom

hi, do you want a software to do this or a simple cronjob ? i can do both

$155 USD in 3 days
(4 Reviews)
3.3
shehzadwork

I have the required skills and expertise. I have done similar kind of work on many projects. Consider me for your this project. I have good knowledge about the relevant concepts to be used for this kind of project. More

$60 USD in 2 days
(5 Reviews)
2.6
manohartvs

Hello, I have seen your requirements and I will have no problem implementing this for you ASAP. I work with SQL Server in a windows based environment on a daily basis and should not have any issues producing thi More

$333 USD in 5 days
(2 Reviews)
2.5
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE More

$277 USD in 3 days
(2 Reviews)
2.4
GhaziOualha

A proposal has not yet been provided

$249 USD in 7 days
(1 Review)
2.2
C0RETECHIES

Hello, We have a team of 30 full time, expert developers having expertise Joomla, Magento, Wordpress & Core PHP. We are willingly to work on this project. We can customize components, modules and plugins from the scra More

$144 USD in 3 days
(1 Review)
1.5
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a More

$40 USD in 2 days
(3 Reviews)
1.1
ekhlai

Hi, ready to help you. But requirement c) doesn't make sense. "update record with "not available" if record not found" It is impossible to update a non-existent record. If record non-existent, you would insert i More

$155 USD in 5 days
(0 Reviews)
0.0
mk73rc

Hi, Task can be done. for how many days you want this task should be done ? Please ping me manojk12 at skype if you are comfortable. Regards, Manoj

$155 USD in 3 days
(0 Reviews)
0.0
alexsanda

A proposal has not yet been provided

$111 USD in 1 day
(0 Reviews)
0.0