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


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.

Taidot: SQL

Näytä lisää: network administrator job, sql server job, table of content, summary table, SSID, Sql reports, sql duplicates, Sql 2012, reports sql server, LOCAL NETWORK, delete duplicate, creating sql, create part, create a 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, sql update text text, stored procedure list

Tietoa työnantajasta:
( 36 arvostelua ) London, United Kingdom

Projektin tunnus: #1731524

Myönnetty käyttäjälle:


Greetings from [url removed, login to view], 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 Lisää

£30 GBP 2 päivässä
(1 arvostelu)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Ready to start this project...

£40 GBP 1 päivässä
(4 arvostelua)