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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 sql

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!


Step1

Create 2 Main tables,
1. Details1
2. Details2
From 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).

"
   

- Advertisement -