Solved

Foreach Loop Container in SSIS

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 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

17 Experts available now in Live!

Get 1:1 Help Now