We have recently published some but not all of the XML schemas used by SQL Server Integration Services to http://schemas.microsoft.com . Most (or all?) of our .XSD schema files are never installed to your hard drive, but are embedded in our compiled code as string resources. Now you can view some of...
In my third installment on Excel issues , I proposed writing out Excel XML rather than binary Excel files as one way to avoid both the issues of the Excel driver, and the risks of Excel automation. Recently I came across a DTS custom task that I wrote in Visual Basic.NET in 2004 that does exactly that...