Solved

Foreach Loop Container in SSIS

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now