-
SSIS Replace existing Records Problem
Can you help me solve the following?
Daily we are loading results to a table that has 5 key fields. It is a simple transformation from a csv file to the database table.
Occasionally the data is preliminary or incorrect in the csv file and needs to be reloaded (primary idenitfier here is date). I want to modify the existing Package to over-write/replace the existing records.
As should be obvious If I try to run the SSIS package with data from the same date I get a key violation and the package fails.
The date key field is in the csv and in the data table; it is not in the file name.
I am not sure of the best way to "check" to see if the data exists first, then delete it if it does, so a reload can occur. We are only talking about a couple hundred small records.
The date key field is in the csv and in the data table.
Thanks
Gregg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|