December 9, 2011 at 8:21 am
let me explain i have three tables and have to write a query that basically joins the tables at row level and in between have some rows that don't have any join criteria(missing the link between the tables due to human error).
now i need to have a query that transforms if there is a join between these three tables and at the same time if it doesn't that join criteria then that record needs to move to the error record and this has to be done in ssis.i'm using ssis 2008 is it possible? if yes how .please do clarify this issue.
demo for clarity
the first table (profile)
column : language
values: aus
rxy
the second table(t2)
column: tbl_name
values :profile
column :tbl_code
values:language
the third table(t3)
column:t3_name
values:language
column:tbl_code
values:aus
column:tbl_desc
values:australian
now i have to join the three tables and get the value Australian to replace the value aus in the first table and the second record has the connection missing in the table t2 as there is no tbl_code associated with now i have to separate these both records has valid data and error data .these has to be done to thirty or more other column and the data in those columns is not as simple.so i should have a query i think in the lookup that does as mentioned above.is it possible?
thanks for the help in advance.
December 9, 2011 at 2:06 pm
can you provide some sample data, have a look at some of the other threads see how when asking for help they add in scripts to create replica data as its easier to work out an answer that way 😀
***The first step is always the hardest *******
December 9, 2011 at 2:22 pm
Parakiti,
I think I get what you're asking for, but I'm not quite sure. As mentioned above, sample schema, data, and desired results from that sample set would be helpful. Check the first link in my signature if you need help in understanding what we're asking for.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply