Posted: 5/8/2012
Hi All,
For my project Source files are Excel and CSV files I've to load those files data into Sql Server table by using SSIS package.I develop SSIS package for running the package,Now my problem is configuration, how design XML configuration for above SSIS package.
I'm unable to find where can I change path of the file folder of the for each loop container?
Can you please give me how to perform XML configuration of SSIS package.
From this configuration I want to change the path of the folder.
Posted: 5/15/2012
You dont need to change the XML. you need a variable. This blog shows you how.
http://www.bidn.com/blogs/mikedavis/ssis/625/loop-through-excel-file-in-ssis