Generate XSD from XML

Hi,

I'm new to SQL2005 and even newer to .XML. I've been using SSIS to bring in some .XML files using the XML datasource in SSIS. I use the "generate XSD" button to read the XML file and build the XSD for me. This works great but it seems that the "generate" button always ends up normalizing out every table attribute into seperate tables, even 1:1 attributes. A 3 table schema with 10 attributes per table ends up coming in as a 30 table schema. In my case it ended up as a 104 table schema. Not knowing a whole lot about .XML I'm wondering if there are tools out there that can be used to gen an XSD off of an XML file but do it in a smarter manner such as keeping all the 1:1 attribute in a single table? I Googled that and found no utilities like that.

Any help is appreciated.

G

After a week I can answer my own question. Inside of Visual Studio there is a utility to generate "intelligent" XSD files. It took my 104 table schema and boiled it down to 3 tables.|||

Hello PM2k - we have a similar need. Could you please point out how to locate the utility you mentioned in Visual Studio that generates the "intelligent" xsd? Any additional background / info you can provide would be most appreciated!

Thanks.

Generate XSD from XML

Hi,

I'm new to SQL2005 and even newer to .XML. I've been using SSIS to bring in some .XML files using the XML datasource in SSIS. I use the "generate XSD" button to read the XML file and build the XSD for me. This works great but it seems that the "generate" button always ends up normalizing out every table attribute into seperate tables, even 1:1 attributes. A 3 table schema with 10 attributes per table ends up coming in as a 30 table schema. In my case it ended up as a 104 table schema. Not knowing a whole lot about .XML I'm wondering if there are tools out there that can be used to gen an XSD off of an XML file but do it in a smarter manner such as keeping all the 1:1 attribute in a single table? I Googled that and found no utilities like that.

Any help is appreciated.

G

After a week I can answer my own question. Inside of Visual Studio there is a utility to generate "intelligent" XSD files. It took my 104 table schema and boiled it down to 3 tables.|||

Hello PM2k - we have a similar need. Could you please point out how to locate the utility you mentioned in Visual Studio that generates the "intelligent" xsd? Any additional background / info you can provide would be most appreciated!

Thanks.

Generate XSD from XML

Hi,

I'm new to SQL2005 and even newer to .XML. I've been using SSIS to bring in some .XML files using the XML datasource in SSIS. I use the "generate XSD" button to read the XML file and build the XSD for me. This works great but it seems that the "generate" button always ends up normalizing out every table attribute into seperate tables, even 1:1 attributes. A 3 table schema with 10 attributes per table ends up coming in as a 30 table schema. In my case it ended up as a 104 table schema. Not knowing a whole lot about .XML I'm wondering if there are tools out there that can be used to gen an XSD off of an XML file but do it in a smarter manner such as keeping all the 1:1 attribute in a single table? I Googled that and found no utilities like that.

Any help is appreciated.

G

After a week I can answer my own question. Inside of Visual Studio there is a utility to generate "intelligent" XSD files. It took my 104 table schema and boiled it down to 3 tables.|||

Hello PM2k - we have a similar need. Could you please point out how to locate the utility you mentioned in Visual Studio that generates the "intelligent" xsd? Any additional background / info you can provide would be most appreciated!

Thanks.

Generate report using XML as data source

Hi
How can I generate report using XML file as Datasource?
And I need to pass XML Filename dynamically at run-time..
--
Thanks in advance
BhaveshToday you have to write a data extension. In the future (Yukon) there will
be controls that can be used and it should be significantly easier to do
this sort of thing (load a dataset with the xml data and pass that to the
control).
Bruce L-C
"Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> Hi
> How can I generate report using XML file as Datasource?
> And I need to pass XML Filename dynamically at run-time..
> --
> Thanks in advance
> Bhavesh|||Pass to which Control?
I am reading XML data in dataset, in my asp page and passing it to Crystal
report control..and everything is working fine..
But I want to do this using SQL Server reporting service..
How can I do this?
Thanks
Bhavesh
"Bruce Loehle-Conger" wrote:
> Today you have to write a data extension. In the future (Yukon) there will
> be controls that can be used and it should be significantly easier to do
> this sort of thing (load a dataset with the xml data and pass that to the
> control).
> Bruce L-C
> "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > Hi
> > How can I generate report using XML file as Datasource?
> >
> > And I need to pass XML Filename dynamically at run-time..
> >
> > --
> > Thanks in advance
> > Bhavesh
>
>|||What I am saying is that with the shipping product you have to create a data
extension. Read up in bol. Version 2 of RS (ships with Yukon, the next
version of SQL Server) will have controls (web and winform) so you can do it
the way you are thinking about.
Another alternative to a data extension is to rethinking where the work is
done. Have the data extraction occur within RS and then integrate in using
either URL integration or Web services.
Bruce L-C
"Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
news:D7E6E9F7-ECFC-493C-9FA5-9F63FDBC241D@.microsoft.com...
> Pass to which Control?
> I am reading XML data in dataset, in my asp page and passing it to Crystal
> report control..and everything is working fine..
> But I want to do this using SQL Server reporting service..
> How can I do this?
> Thanks
> Bhavesh
> "Bruce Loehle-Conger" wrote:
> > Today you have to write a data extension. In the future (Yukon) there
will
> > be controls that can be used and it should be significantly easier to do
> > this sort of thing (load a dataset with the xml data and pass that to
the
> > control).
> >
> > Bruce L-C
> >
> > "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> > news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > > Hi
> > > How can I generate report using XML file as Datasource?
> > >
> > > And I need to pass XML Filename dynamically at run-time..
> > >
> > > --
> > > Thanks in advance
> > > Bhavesh
> >
> >
> >|||Thanks Bruce..
"Bruce Loehle-Conger" wrote:
> What I am saying is that with the shipping product you have to create a data
> extension. Read up in bol. Version 2 of RS (ships with Yukon, the next
> version of SQL Server) will have controls (web and winform) so you can do it
> the way you are thinking about.
> Another alternative to a data extension is to rethinking where the work is
> done. Have the data extraction occur within RS and then integrate in using
> either URL integration or Web services.
> Bruce L-C
> "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> news:D7E6E9F7-ECFC-493C-9FA5-9F63FDBC241D@.microsoft.com...
> > Pass to which Control?
> > I am reading XML data in dataset, in my asp page and passing it to Crystal
> > report control..and everything is working fine..
> >
> > But I want to do this using SQL Server reporting service..
> > How can I do this?
> >
> > Thanks
> > Bhavesh
> >
> > "Bruce Loehle-Conger" wrote:
> >
> > > Today you have to write a data extension. In the future (Yukon) there
> will
> > > be controls that can be used and it should be significantly easier to do
> > > this sort of thing (load a dataset with the xml data and pass that to
> the
> > > control).
> > >
> > > Bruce L-C
> > >
> > > "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> > > news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > > > Hi
> > > > How can I generate report using XML file as Datasource?
> > > >
> > > > And I need to pass XML Filename dynamically at run-time..
> > > >
> > > > --
> > > > Thanks in advance
> > > > Bhavesh
> > >
> > >
> > >
>
>