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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 large xml input files

Author  Topic 

Daniel_Buchholz
Starting Member

28 Posts

Posted - 2002-04-29 : 03:05:48
Good morning! (GMT+2)

Is there any way to import large xml formatted files from stored procedures?

I know I could SELECT FROM OPENXML but this is limited to maximum varchar size. But we have XCBL product catalog files with easily over 10000 products in it.

There would also be the possibility to use the SQLXML package but that would mean to write a small script that will run outside of SQL server...

Daniel

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-29 : 10:14:21
Microsoft has an XML Bulk Load COM component that you can use for this purpose. Take a look here:

http://search.microsoft.com/gomsuri.asp?n=1&c=rp_Results&siteid=us/dev&target=http://msdn.microsoft.com/library/en-us/dnsql2k/html/sqlxml_bulkloadover.asp

Also look through this section:

http://www.sqlteam.com/FilterTopics.asp?TopicID=128

There's some discussion on how to use XML with SQL Server, there may be a workaround if you don't have the SQLXML utilities. You can also try:

http://www.microsoft.com/sql/techinfo/xml/default.asp

Go to Top of Page
   

- Advertisement -