
January 25th, 2005, 12:55 PM
|
 |
Unholy Moderator
|
|
Join Date: Oct 2003
Location: In hell, where did you think?
|
|
|
Give me an estimate on how long you think it would take to do the following, with brief explanation of how you would do it.
1) Import 5 text files into staging tables in a SQL Server database.
2) Compare data in staging tables to 5 other corresponding tables.
3) If record exists in its corresponding table, update the record, If not add a new record.
I get updates every month in txt format, some comma delimited some tab delimited, that I need an application to import these files into my staging tables and then update any existing records or add any new records.
|