Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2007-05-01 : 00:28:21
|
| hi, I am new to XML explicit and I need to create an XML file exactly like this below with the version and CreatetionDateTime and so forth. Where do I go from here? In addition, I am thinking on using this for DTS by placing the SQL query in SQL task and output to an xml file format. Is that possible please advise .Thanks. <?xml version="1.0"?><DDMM CreationDateTime= 2004/10/11T16:40:23Z" Granularity="Inct" FileType="Transactional" FileOID="1" AsOfDatetime="2006/10/20T16:40:23Z" PriorFileOID="0" Description=" Tracer file can contain many customers"> <MedData StudyOID="AAABB112" MetaDataVersion="MDV.1"> <SubjectData SubjectKey="4999"> <SiteRef LocationOID="T55544"/> <StudyeventData StudyEventOID=""> <FormData FormOID=" PTID"> <ItemGroupData RepeatID="1" ItemGroupOID="MAIN"> <ItemData ItemOID="SJNUM" value="4999" TransactionType="Insert"/> <ItemData ItemOID="SJIT" value="XYZ" TransactionType="Insert"/> </ItemGroupData> </FormData> </StudyeventData> <StudyeventData StudyEventOID="CHECK"> <FormData FormOID="TELE"> <ItemGroupData RepeatID="1" ItemGroupOID="MAIN"> <ItemData ItemOID="ACCEPTED" value="2004 10 11" TransactionType="Insert"/> </ItemGroupData> </FormData> </StudyeventData> </SubjectData> </MedData></DDMM> BTW do I need a DTD to view this file and how do I parse it in DTS. Thanksk |
|
|
|
|
|
XML Explicit with the xml version included?