Loading multiple XML file with different Metada In SQL Server Tables with SSIS 2008
Hi, I have multiple xml data file in a directory say C:\XMLData\ abc1.xml, abc2.xml, abc3.xml etc. Need to loop through each file in ssis with Foreach loop container, and get the file name say abc1, and load the data of abc1.xml to abc1 table in sql server DB. next iteration will pick up the abc2.xml and find the abc2 table in sql server DB then insert the data in abc2 table. while each iteration, xml source should also point each xsd file correspondingly. Tables are already created in DB I solved my problem up to getting the file name from ech iteration and assigned file name to variable, in oledb destination data access mode I select Table or view name variable, then corresponding table will get selected for data insertation. Just wanted to know how can I read each xsd file for each xml data files while iteration. Any early help will be appreciated. Sandeep VaishyaThanks Sandeep Vaishya
February 17th, 2011 12:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics