SSIS 2008: XML ==> SQL Server....Create Tables and then Insert Data all in one step

SSIS 2008:

I know I have installed the SSIS, but had to spend 30 minutes to figure out
how to get into it.....had to go into it through Visual Studio Business
Intelligence Icon (Dumb, Dumb, Dumb)

When they change something so draaaaaaaaaaaaaaaaaastically, they should make
some effort to minimize the initial hatret ....ie. keeping the previous "How
Do I Start This Darn Thing" path somewhat similar to the previous version.



Don't understand why Microsoft had to do GUI so "UNINTUITIVE" and
COMPLICATED and FRUSTSTRATING to use.



I am trying to use the below 2005 instructions with the 2008 version. About
to kill myself. I can write serious programs with my eyes closed, but
cannot figure out a simple task with new tools.



Came to step 5/6. Added an OLEDB connection.....but the think is I want
SSIS to create tables.

XML data is valid, XSD Schema data is valid (does not have annotation
section)



Tried importing to Access.....it is easy, it worked....over 255 field length
were cut off, though.



Want to do the same thing with SSIS.........but it is just frustrating.

This is a single XML/XSD, but goes into multiple tables and tables are not
there....SSIS needs to create.



Do I want to much?



++++2005 SSIS Post/Help/Instructions++++++++++++++++

I just tried the following and it worked. Try:
1.. Create a new ssis projet
2.. Add a data flow task
3.. Add an XML source
4.. From the properties, select ANY xml file as source, and select your
XSD file in 'xsd location'
5.. Add an OLEDB destination and link to the source.
6.. From the properties, connect to a sql server database.
7.. click on NEW where it asks you to select 'table or view' and it will
give you the script of the table (based on the xsd schema)
regards

Jacob