Hi,

I am a newbie to SSIS, all I want to do is to push the xml data from a
xml file into a table in SQL and I know I can do it thru' SSIS.

Here is what happens:
1. I create a XML source which pts to my xml file and I generate the
xsd file on the spot (the option available at this XML source)
2. Then I create an OLE DB destination, which link to the SQL server
and table...
3. I use the green arrow and drag from the XML source to the OLE DB
destination, however, I am only allow to pick one field from the xml
file, but what I want is to push all fields from the xml file to the
table? Anything I am missing here?
4. Again, when I am trying to do the mapping within the OLE DB
destination, I am only given 2 columns to map, but I have more columns
than that.

Please help. Thanks in advance. Your help would be greatly
appreciated.