Create Sql server script to import/replace data every 12 hours

$30-250 USD

Completed

Posted

almost 11 years ago

$30-250 USD

Paid on delivery

I have a table that needs to be imported or replace the data in a table every 12 hours or daily. I am using sql server 2012. I am attaching a sample of the data we receive each night. You will need to use your own sql server on your computer then supply us with the script. You will not have access to the server.

Database Administration

Software Architecture

SQL

Project ID: 4789670

About the project

23 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@tuanlm101

Hello, I am interested in your project and finished the work already. Let's get the job done in several minutes.

$110 USD in 1 day

5.0

(10 reviews)

4.7

23 freelancers are bidding on average $76 USD for this job

@feninsoftech

Hi, This can be achieved by BULK INSERT in SQL Server. First script will load text file data in sql temporary table using bulk insert. Then data will be inserted in permanent table in transaction. I have 8.5 years experience in SQL Server development.

$88 USD in 3 days

4.9

(53 reviews)

6.9

@samitXI

PLease check your inbox. Thanks

$103 USD in 5 days

4.8

(57 reviews)

6.7

@prakashmondal

hi, I can do this job using windows scheduler. Please see PM.

$100 USD in 3 days

5.0

(52 reviews)

5.9

@thanhlongfree

Hi. I can do this for you quickly. Please provide the table structure

$74 USD in 3 days

4.7

(31 reviews)

5.8

@elboukharimu

I can help you, please check your Inbox.

$95 USD in 3 days

4.6

(34 reviews)

5.4

@sswijaya

Hi, let me help you with this.

$35 USD in 1 day

5.0

(19 reviews)

4.7

@abhinitd

Hey, I have extensive experience on T-SQL programming and most of the Microsft based technologies/platforms in general. I can do it for you right away. Cheers..! Abhinit

$55 USD in 1 day

5.0

(6 reviews)

3.9

@tamerelanwer

Dear Sir I am interested in working in this project. Please find my resume attached. Regards Tamer Khalil

$61 USD in 2 days

5.0

(6 reviews)

3.8

@anshumanvermaUK

Hi I have 4 years of experience in MS SQL. Please share the target table schema in which this data should be populated.

$30 USD in 3 days

5.0

(1 review)

2.7

@shael1

Hi, Please see the Private Message. Regards, Shael.

$35 USD in 3 days

5.0

(1 review)

1.9

@luki555

Hi. Check your PM please. I sent you my proposal.

$40 USD in 2 days

5.0

(2 reviews)

1.3

@vjain14

Hi , I am well versed with MySQL to do this project. Please consider bid.

$45 USD in 2 days

5.0

(1 review)

1.1

@johnjayper

Sir, I am ready to work with you, promise you wont disappoint my work, please see PM

$30 USD in 3 days

1.0

(1 review)

3.0

@RohitNigam91

Hello, I have worked on the functionality that is desired for populating the data in the table once in a day and removing redundant data. I have implemented it when the date change i.e 00:01Hrs. Therefore I could work on your requirement. Thanks

$100 USD in 3 days

0.0

(0 reviews)

0.0

@ernesb

Dear Sir, i could do it using SQL Server Integration Services (SSIS) script, also you could configure this script to be executed as required, every 12 hours, daily, weekly, anything you want. I will give you clear documentation of how do this step by step on your server.

$111 USD in 4 days