<div>
refer this<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms345182(v=sql.90).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms345182(v=sql.90).aspx</a>
</div>


refer this

http://msdn.microsoft.com/en-us/library/ms345182(v=sql.90).aspx [http://msdn.microsoft.com/en-us/library/ms345182(v=sql.90).aspx]

<div>
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
</div>


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

<div>
Hi<br />
<br />
Got this to work I did it in the Code and did not use a Foreach Loop Container
</div>


Hi

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

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
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.
</div>
</div>


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.

Foreach Loop Container in SSIS

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.