Solved

Foreach Loop Container in SSIS

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Union & Crosstab qrys 101! 6 53
Can I skip a node in XML? 9 30
Vb.net progressbar with timer1 in visual studio win app 11 34
VB.Net  Exporting Excel Woorkbook to PDF 7 58
In this article I will describe the Copy Database Wizard 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

740 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