Professional: Microsoft® SQL Server® 2012 Integration Services by Brian Knight & Erik Veerman & Jessica M. Moss & Mike Davis & Chris Rock

Author:Brian Knight & Erik Veerman & Jessica M. Moss & Mike Davis & Chris Rock
Language: eng
Format: epub
Publisher: John Wiley & Sons
Published: 2012-03-03T16:00:00+00:00

If you click the Browse button, a regular File Open dialog opens. It isn’t obvious at first that you can use a URL instead of a file on disk.

The XML file must be defined with an XML Schema Definition (XSD), which describes the elements in the XML file. Some XML files have an in-line XSD, which you can determine by opening the file and looking for xsd tags. There are many resources and tutorials available on the web if you want to learn more about XML schemas. If the file you are importing has an in-line schema, make sure that Use inline schema is checked. If an XSD file is available, you can enter the path in the XSD location property (see Figure 13-27). In this case, you will create the XSD file right in the Source adapter:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.