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
Solved

Foreach Loop Container in SSIS

Posted on 2011-03-10
4
339 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
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Correct an issue with a where clause with calculation 2 39
Microsoft Access Delete all Records from table but Max 2 24
SQL Select in Access 2003 3 25
Trouble with <> 2 20
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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