Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Foreach Loop Container in SSIS

Posted on 2011-03-10
4
Medium Priority
?
346 Views
Last Modified: 2012-05-11
Hi Experts

I have a excel file to upload loop through the excel file extracting each records and placed it in it's own XML file. So if there's 10 records in the Excel file I will have 10 XML files.
0
Comment
Question by:abooysen2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 35094142
0
 

Author Comment

by:abooysen2
ID: 35094233
I had a look at this sample before but mine keep on failing. I have my Foreach Loop Container that picks up the excel file but when I extract the multiple xml files it fails
0
 

Accepted Solution

by:
abooysen2 earned 0 total points
ID: 35094894
Hi

Got this to work I did it in the Code and did not use a Foreach Loop Container
0
 

Author Closing Comment

by:abooysen2
ID: 35135819
Hi

Got this to work I did it in the Code and did not use a Foreach Loop Container
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question