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 |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2006-06-12 : 06:44:49
|
Hi all,Looking at trying to get an XML file imported into a table for manipulation.Given this piece from BOL, I have hopes that Bulk Insert in 2005 can handle XML:quote:
Bulk Exporting or Importing SQLXML DocumentsTo bulk export or import SQLXML data, use one of the following data types: Data type Effect SQLCHAR or SQLVARYCHAR The data is sent in the client code page or in the code page implied by the collation). The effect is the same as specifying the DATAFILETYPE = 'char' without specifying a format file. SQLNCHAR or SQLNVARCHAR The data is sent as Unicode. The effect is the same as specifying the DATAFILETYPE = 'widechar' without specifying a format file. SQLBINARY or SQLVARYBIN The data is sent without any conversion.
Am I mistaken? If so, is SSIS the only way to get XML data into a SQL table?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
Import XML file via Bulk Insert?