Jul
19
2008

Some of the XML schemas used by Integration Services are now published

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 those schemas online.

What we have NOT published

  • The .DTSX package schema.
  • The schema for the service configuration file, MsDtsSrvr.ini.xml.
  • The schema for XML configuration files.

What we HAVE published

Gotcha

Note that the URLs of the published schemas DO NOT MATCH the "targetNamespace" URIs that are actually used inside the .xsd files. Why is this? Because the dude in charge of publishing XML schema guidelines for our developers didn't get around to publishing his guidelines until after SQL Server 2008 was finished. By that time the targetNamespaces could not casually be changed. It's my hope that we will make targetNamespace URI match published URL in the future. Meanwhile I thought that the potential value in publishing some of our schemas outweighed the inconvenience of this mismatch.

-Doug