Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding a Header Row to a SSIS package exporting out as XML Expand / Collapse
Author
Message
Posted Wednesday, July 9, 2014 5:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 12:02 PM
Points: 22, Visits: 46
I've been asked to create an SSIS package to export data out as and XML file.
I've got the xml file down but now the customer is wanting a header row added to the first line of the xml file.
I've tried adding it in the Header row for the flat file destination but getting an error that it cannot parse the Header file.
Any suggestions would be appreciated.
Thanks in Advance

Wayne
Post #1590689
Posted Wednesday, July 9, 2014 11:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 11,157, Visits: 12,899
What do you mean by a header row? By definition XML doesn't have rows, it has elements and attributes.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1590868
Posted Wednesday, July 9, 2014 12:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 12:02 PM
Points: 22, Visits: 46
I had created the SSIS package to pull just the student data.
What the vendor was wanting was the XML information <?xml version="1.0" encoding="utf-8"?> added to the first row of the extract.
I finally found the place to add it and how to add it after several searches.
Thanks
Post #1590896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse