Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

INFOPATH DOCUMENTS

This example demonstrates the ability of SSIS to interact with an external Microsoft Office application — namely, InfoPath.

image

Microsoft InfoPath is a desktop forms client that provides a rich interface to XML-based documents.

Using a document created from the Timecard template supplied with the downloads for Chapter 21 (in the InfoPath folder), you will import portions of data stored in an InfoPath document and output the results to a comma-delimited flat file.

Portions of imported data in this demonstration appear disconnected in the Data Flow Task. This example demonstrates an SSIS method to join disconnected data. It also covers some troubleshooting. Many thanks to Wenyang Hu for permission to reuse some elegant XSL!


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint