Change path of Source folder path in Foreachloop container from XML configuration

Who is online?  0 guests and 1 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Change path of Source folder path in Foreachloop container from XML configuration

Change path of Source folder path in Foreachloop container from XML configuration

Topic RSS Feed

Posts under the topic: Change path of Source folder path in Foreachloop container from XML configuration

Posted: 5/8/2012

Jedi Youngling 60  points  Jedi Youngling
  • Joined on: 3/31/2011
  • Posts: 20

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

Jedi Master 5325  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 298

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

 


Page 1 of 1 (2 items)