Lookup with Xml file

• chatwithkrishan

  Ten Centuries

  Points: 1056

  More actions

  August 23, 2009 at 11:51 pm

  #133122

  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 ??

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 24, 2009 at 7:21 am

  #1043608

  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

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  August 25, 2009 at 3:42 pm

  #1044572

  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.

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden