Cindy,

First off thanks for the article, it is very timely for me.

I tried this using SSIS 2005, with VB.Net as the script language with a SQL Server 2005 back end.

I was able to translate the C# to VB and have the scrip working just fine.

And while building the Data Flow portion of the package every thing went smooth, regardless of which XSD I used, the columns mapped just fine and every thing look good to go.

However, when I execute the package I get the nasty RED on the xml Source object and the two following error messages.

[XML Source [390]] Error: The component "XML Source" (390) was unable to read the XML data.

[DTS.Pipeline] Error: component "XML Source" (390) failed the prepare phase and returned error code 0xC02090D0.

I have tried Googling these messages but am getting no where in my attempts to trouble shoot the error.

Do you have any thoughts, solutions or directions to point me?

Thank you,

Jonathan