Hi There,

The process for loading .csv files or .txt files is pretty much clear.

But the process to load xml files is a bit confusing since I can't use Flat File Connection manager to get the data from .xml files and to set the Connection String proprty.

Please give me the detailed process to load the .xml files into db using For Each Loop container in SSIS.

Please reply if I am not elaborative about the problem.

Thanks,

Srinivas