Home / General / SSIS: Using InfoPath XML Files in SSIS XMLSource Adapter
digWin is a community news sharing site for Microsoft Techies. Share interesting news/links and rate them!

SSIS: Using InfoPath XML Files in SSIS XMLSource Adapter

posted by  jhorra (5)  12 months ago (www.sqljunkies.com)

Thanks to Wenyang for writing all this up! Just posting it on her behalf.


 


 


Summary

InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This a





add comment email this category: General


Related Stories

Using system variables in SQL Server 2005 Integration Services applications

The use of variables is vital to any type of program, and SQL Server 2005 Integration Services (SSIS) is no different. S.. more »

WSS Adapter handling of InfoPath forms with attachments

InfoPath supports forms with file attachments by encoding the attachement as base64 and including the following PI <?.. more »

Extending SSIS webcast later today

At 1PM PST today, I'll be doing an MSDN Webcast on how to extend Integration Services including how to write new tasks a.. more »

Integration Services @ TechEd U.S.

Kamal and I are going to be presenting three sessions between us on Integration Services at the TechEd in a few wee.. more »

Set up OLE DB source to read from View efficiently

 IntroductionOLE DB source adapter is one of the most commonly used components in SSIS data flow task. In this arti.. more »



Microsoft news, tips and tricks search

Comments


Post voted by 1 digWinners


Featured Links

User

Login | Register




Forgot Password?

Sponsor

Anti spam filter for mail servers
Anti spam, anti phishing and email management software for Exchange/SMTP/Lotus. Download a FREE trial!

Featured

Download Free Exchange Ebook

Categories

Upcoming NEW

Recent comments

Related Sites

  about | tools | blog | advertising | feedback | privacy | terms of use