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.
| Author |
Topic |
|
govindts
Starting Member
33 Posts |
 Posted - 2008-01-26 : 23:30:49
|
| Hello all,I am using SQLSERVER with SSIS tool. I have a XML file and wanted to load into sqlserver database. The XML file data are mapped to 5 or 6 tables. How do i load the XML data into all these tables. Please help me how to do it. Thanks and appreciate if any one could help me on this... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-27 : 00:41:54
|
| Did you try using xml source and oledb destination tasks inside DFT? |
 |
|
|
govindts
Starting Member
33 Posts |
Posted - 2008-01-27 : 13:49:57
|
Hello, OLE DB destination task is not helping. I wanted to route the signal XML file to multiple tables..quote:
Originally posted by visakh16
Did you try using xml source and oledb destination tasks inside DFT?
|
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-27 : 15:36:21
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
|
|
|
Import the XML data into database