|
Home > Archive > MS SQL XML > July 2005 > Insert large number of xml documents into SS 2005 xml column
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Insert large number of xml documents into SS 2005 xml column
|
|
|
| I have problem I need to put >1000 unstructured XML documents into an already
existing xml column of my sql server 2005 DB via ADO.NET. To say that
performance is very lacking is an understatement, can the new SqlBulkCopy
handle an XML datatype and if so how should I give it to the DataTable (the
data is coming from a web service and can not be easily shredded into a
relational model), i.e. how can I tell the DataTable that the column is XML
not just a string.
If anyone has any suggestions please speak up.
Thanks,
blair
| |
| Michael Rys [MSFT] 2005-07-16, 3:23 am |
| How do you insert it today?
And yes, bulk copy mechanisms can load XML. You should indicate it as
SQL_BINARY and the implicit cast will take care of it.
Best regards
Michael
"blair" <blair@discussions.microsoft.com> wrote in message
news:0625F56E-2AD4-4D92-AB70- 6D2DD2221C01@microso
ft.com...
>I have problem I need to put >1000 unstructured XML documents into an
>already
> existing xml column of my sql server 2005 DB via ADO.NET. To say that
> performance is very lacking is an understatement, can the new SqlBulkCopy
> handle an XML datatype and if so how should I give it to the DataTable
> (the
> data is coming from a web service and can not be easily shredded into a
> relational model), i.e. how can I tell the DataTable that the column is
> XML
> not just a string.
>
> If anyone has any suggestions please speak up.
>
> Thanks,
>
> blair
| |
|
| Thanks, Michael I will try your suggestion.
blair
"Michael Rys [MSFT]" wrote:
> How do you insert it today?
>
> And yes, bulk copy mechanisms can load XML. You should indicate it as
> SQL_BINARY and the implicit cast will take care of it.
>
> Best regards
> Michael
>
> "blair" <blair@discussions.microsoft.com> wrote in message
> news:0625F56E-2AD4-4D92-AB70- 6D2DD2221C01@microso
ft.com...
>
>
>
|
|
|
|
|