Re: Combining XML Files using SSIS or T-SQL etc.

SSIS now has a Control Flow Item called Foreach Loop Container. You use this
to loop through all the xml files in a specified directory. You will also
need to create a Data Flow Task in the Foreach Loop Container. The samples
that come with SQL Server 2005 have an example of using this container
control, and you can find more info in BOL.

--
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
"Terry" <Terry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5EAFCB63-AC58-4592-A7DF-786AF5CABBBF@xxxxxxxxxxxxxxxx
What is Loop?

Could you please explain more in detail.

Thank you in advance for your assistance.

"Peter W. DeBetta" wrote:

Loop?

--
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
"Terry" <Terry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:187DB17A-FA31-4236-844A-7068BE9C072E@xxxxxxxxxxxxxxxx
How can I combine all my xml files so it can be processed by SSIS in
order
that I may create a table containing the imported xml files?







.

Loading