Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 7th, 2006, 01:23 PM
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSIS :: Reading from XML source into Recordset

  In "Data Flow", I am attempting to use "XML Source" to read a XML document into a recordset and in "Control Flow", into a Foreach Loop Container ( foreach ADO enumerator ), where I map the attributes to DTS variables. SSIS allows you to specify the input columns by means of an index number. The problem is you don't know what index value to use for a particular input attribute. It does not seem to be in the same order as the what the XML input is. This is very troublesome. Ideally, you should be allowed to select the value based on attribute name.
  Has anyone seen this problem ? Any ideas ?
Thx.
Reply With Quote
  #2 (permalink)  
Old January 12th, 2016, 06:48 AM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2015
Location: Miami Lakes, FL 33015
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Reading from XML source

Hello,
Here I would like to mention some steps that How to start working with XML source.
1.In BIDS/SSDT create new SSIS package
2.From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.
3.Double click on the DataFlow task to see DataFlow designer surface.
4.From the SSIS toolbox drag and drop XML Source on the dataflow designer surface.
5.Double click XML Source to configure it.
6.From the Access Mode dropdown select [File path or web Url] and paste the following Url for this example .
7.Now enter Path expression in Path textbox to extract only specific part of XML file as below ($.GeocodeResponse.result.address_component[*] will get content of address_component array attribute from XML document. address_component attribute is treated as array because appear more than once under same parent node, so we have to use[*] to indicate we want all records of that array)
8.Click preview to see our settings are OK.
9.Now one issue with XML parsing is how to determine which element(s) should be treated as an Array so expression engine can parse[*] type of expression correctly? For that you can type list of Elements names (comma separated) under Array Handling tab. In our case we want to treat type element as Array as below
10.Click OK to save settings.
11.From the SSIS toolbox drag and drop Trash Destination on the dataflow designer surface.
12.Now single click on the XML Source, once you see blue arrow from source ... connect it to Trash Destination.

We have also sample work with snapshort and one more video where task is discussed. If you got trouble You can follow us here
http://zappysys.com/products/ssis-po...is-xml-source/
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SSIS XML as a destination? GethWho BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 5 February 3rd, 2016 07:22 AM
SSIS Package:RawFile Source,FlatFile Destination Mit_2807 BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 September 19th, 2008 04:01 AM
Connect a package of SSIS (dtsx) like data source Edwin2008 SQL Server DTS 1 January 7th, 2008 10:49 PM
Values from recordset lost after reading vanik.cz Classic ASP Databases 11 January 4th, 2008 06:36 AM
Hard (recordset field) reading fskilnik Dreamweaver (all versions) 10 November 28th, 2005 05:05 PM



All times are GMT -4. The time now is 04:08 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.