August 20, 2015 at 11:06 pm
Hi ,
In my SSIS Package I am loading data from source to destination.
I am using lookup to get the matching and not matching records.due to identity on itmkey i want to load matching record first then non matching records.
can we hold the data path under DFT.
Kindly find the attachment to understand the scenario.
August 21, 2015 at 12:15 am
Usually Not-Matched records are generated because of an exception in data or the lookup table does not have the current snapshot of the data you are loading.
i would suggest if you are getting not matched rows you 1st insert/update the lookup table 1st. by doing this if you still get not matched records then that will be your true exception. dump it in a file or in a Error log table for further investigation.
Having said that to answer your question. Yes you can do that i-e Matched record 1st and Not-Matched buy doing this
1. Create a separate table ( something like "ItmNonMatch") to hold the Not-Matched records. No change is required for the Matched records insertion.
2. Create a new DataFlow OR you can also create a SQL Execution Task and perform your transformation and insertion in that task.
hope it helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply