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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-10-08 : 05:02:59
|
| How is it possible to pass the xml content of a file from xml source to a table variable?I would then like to query the table variable and pass the required data into other tables.I do not want to create a permanent table to hold the initial xml contents.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 05:49:45
|
| if you want xml field data to directly passed to some table, then just use xml source & OLEDB destination. Alternatively you could just create a raw file and dump your xml data to it and then use it in ssis for further processing also. More details on what you're trying to do will help to provide more accurate suggestions. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-10-08 : 06:39:43
|
| At present the ssis package takes the data from xml file using xml source and puts it into a permanent table and then more queries are done on that table...I would like to have a tamp table instead of the permanent table to hold the initial xml data. And so I can use the temp table to take the required data into other tables.How is this done please?Thanks |
|
|
|
|
|
|
table variable