Đang Thực Hiện

Create an automated SQL table rebuild from flat file

I have 2 tables in SQL 2005 Standard edition which are created from a text files daily and I would like to create a stored procedure which can run every run hour automatically to update these tables from the text files which are stored on my local network.

I am happy with the process of creating the stored procedure but it will not run and reports this error

**

Date 02/07/2012 11:31:44

Log Job History (CID Product Update Part 1)

Step ID 0

Server SHE-SQL01

Job Name CID Product Update Part 1

Step Name (Job outcome)

Duration 00:00:01

Sql Severity 0

Sql Message ID 0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted 0

Message

The job failed. The Job was invoked by User AD\administrator. The last step to run was step 1 (Run FUll SSID Update).

**

When the tables are currently created we have to delete the previous content because otherwise it duplicates the entries rather than updating them with new entries and existing content column updates which would be the preferred option.

In summary I require a stored produced which will update 2 tables every hour from text files stored on my network. The tables are a list of products and I would rather update/replace/add existing/new records rather than deleting the existing content but I cannot have duplicate product codes in the tables.

Kỹ năng: SQL

Xem thêm: network administrator job, sql server job, summary table, ssid, sql reports, sql duplicates, sql 2012, reports sql server, local network, delete duplicate, creating sql, create part, create flat, sql update text, duplicate table, sql created, update sql file, net run administrator, update text sql, product table, server 2012 standard, create tables sql 2012, stored procedure list, text table, duplicate file

Về Bên Thuê:
( 36 nhận xét ) London, United Kingdom

Mã Dự Án: #1731524

Đã trao cho:

RhlGyl

Greetings from Deusden.com, Having worked on database for past 4 years I am confident of your requirement, I would be happy to be considered for the project. Requesting you to consider us for your requirements, w Thêm

£30 GBP trong 2 ngày
(1 Đánh Giá)
1.4

2 freelancer đang chào giá trung bình £35 cho công việc này

sriraj1233

Ready to start this project...

£40 GBP trong 1 ngày
(4 Đánh Giá)
3.8