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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Create SQL Table from XSD without the XML file?

Author  Topic 

GregDDDD
Posting Yak Master

120 Posts

Posted - 2011-03-24 : 19:53:44
I have the XSD files but I don't have sample XML data files yet. Can I still use the XSD files to create the SQL tables using SSIS? Examples I've found assume I have an XML data file.

I'm new to SSIS and I'm having trouble getting anything to work. Am I just spinning my wheels without the XML files? I was hoping to create the structure and add some dummy data so I could begin to program to it.

Greg

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2011-03-25 : 07:05:13
Don't know if this will help but there are tools to generate an XML file from an XSD, adding dummy data. The one I have used for this is the freeware version of Liquid XML Studio, not sure if that version is still available but there should be other similar tools available

-----------

If debugging is the process of removing software bugs, then programming must be the process of putting them in.
Go to Top of Page
   

- Advertisement -