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 |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2007-08-28 : 08:47:50
|
| I have set up a XML source and a target OLE DB source, but when I connect these a dialog promps saying Input Output Selection where I can choose Output and Input. When I click the Output combobox all groups from the XML file are shown and I do not want this, I only want to have ONE to choose.The problem as I see it is that the XML file contains a structure as below:<?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution solutionVersion="1.0.0.312" productVersion="12.0.0" PIVersion="1.0.0.0"?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?><my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-08-09T06:46:49"><my:mankind> <my:fname>Test</my:fname> <my:lname>Testsson</my:lname> <my:kon>blaha</my:kon> <my:group70> <my:group71></my:group71> <my:FE10Manuellt>false</my:FE10Manuellt> <my:temp1>false</my:temp1> <my:temp2>false</my:temp2> <my:temp3>false</my:temp3> <my:temp4>false</my:temp4> <my:temp5>false</my:temp5> <my:temp6>false</my:temp6> <my:temp7>false</my:temp7> <my:temp8>false</my:temp8> </my:group70> </my:mankind></my:myFields> Can anyone point me in the right direction to get rid of this problem.Can a solution be to add an XML task that removes the structure and rebuilds it so that the tags is directly under the root? And how do I do that.//Thanks in advance. |
|
|
|
|
|
Problem with XML import.