August 23, 2009 at 11:51 pm
Hi all,
i import data from flat file to database Tables.
before that i want to check validation and lookup.
for validation i used NxBre RulesEngine( 3rd Party ). that is done.
i used Xml file for validation. so i can easy change the validation when i need.
i want to do lookup as like validation with xml file. i will define all lookup value in xml file .so i an change it.
i designed my xml file like this
how can do lookup with out use DB tables ??
August 24, 2009 at 7:21 am
You need to enclose your xml fragment within code tags (with ="xml" in the opening tag), see the IFCode shortcuts to the left of the textbox, in order for the forum to display XML. We can't see the XML right now.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 25, 2009 at 3:42 pm
How many rows will you be importing from your flat file?
You can use the XML source component inside the same data flow as your flat file source. Use the Merge transformation to bring the values from the XML pipeline into your flat file pipleline. Send the merged data sets to your destination.
You'll need to do as Jack suggests and re-post your xml using the tags if you need more help on this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply