I do apologise, this is a beginner SSIS question but I am not really sure of the resources to use.

If I have an XML without an XSD what is the best way to create and import data in SQL Server? I know I can use xsd.exe to create an XSD from my XML.

But if I want my structure to be somewhat different in SQL server how would I go about creating a reliable and repeatable import system for my data so i can easily manage the data up

you can create a table based on current structure and use xpath functions to populate data from xml so far as xml structure doesnt change

see

http://visakhm.blogspot.ae/2012/10/shred-data-as-well-as-metadata-from-xml.html

Hi the link goes to a page does not exist error.