Discussion Locked

SQL 7 missing records issue

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 3 tables that have an ID field in common. Twice a year records are imported in from a file we receive from a governing board. If new records are found in the file, records are added to one of the tables, but the process leaves out the othertwo tables. (the process was developed before the other tables existed) I need to know how to insert records into the other two tables, duplicating the id and adding other info only for these new records. I've tried inderts and updates to no avail. Not sure what I'm missing. Any help would be greatly appreciated.

1 reply

by skavoian

is the dts wizard. use dts designer if you are experienced with this tool. Or course, use a staging server when trying this out. You'll have to read in the sql server resource kit, as there are restrictions to what you can do with hetrogenous datatypes. All the restrictions are outlined in the resource guide.

This discussion is closed to new replies.