Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-11-23 : 07:03:42
|
cini writes "Hi guys,I have some prob.can u help?please!Step1Create 2 Main tables,1. Details12. Details2From the excel data we are getting from another system, with an extra field for date to identify the date in which the data is loaded to these tables. The purpose is for keeping an audit trail.Everyday, data from the excel file is loaded to another set of tables which contain exactly the same fields as the main tables. We need to delete the old data before loading each day’s new records. After loading the contents, the records in the main tables will be compared against that of the new tables. If any changes or new records are identified those will be added to the base table.Step 2 All the records added, deleted, updated (whatever operations are done) each day will be inserted into the audit table.Step3 All the new records, amended ones, deleted will be produced in the required format with the Header and Trailer attached.Ø The record delimiter is ‘#’Ø No field delimiter. Because fields are of fixed lengthØ Maximum record length is 1200 and block size is 12004Ø The file sequential number in the header record should begin 1 and be sequential for all subsequent files. All should be done automatically (scheduled). " |
|
|
|
|