Thanks for the info.

Could you tell me how it makes the data harder to work with? The reason i am trying to do something like this is because we receive...

Well this is the easiest xml to do. But i have about 20 XML files to import. And creating 20 different connections could be a propblem IF they add extra...

When i try importing using the XML source it gives me a message:

Error at Data Flow Task 1 [XML source [1]]: The XML Source Adapter does not support mixed content...

Hi,

With SSIS 2005 you can only import 1 column at a time using the XML source component. i know 2008 handles the XML better so for now rather than creating...

Hi,

These are the two tables being used:

--This one holds the inital imported data

CREATE TABLE

[dbo].[XMLLoading]

(

[ID] [int] IDENTITY(1,1) NOT NULL,

[ColumnSource] [varchar](8000) NULL

)

--This one is used to hold the new cleanedData with...