SSIS - XML Data Type (Column) -
09-08-2006
, 07:07 AM
What is the best way of exporting an XML data type column so it can be read
by SSIS?
I've tried the following T-SQL statements to no avail. The XML source task
is unable to read the XML file.
select * from table for xml path
----------------------------------------------
<row>
<tID>1</tID>
<Checkout_Seq_No>1001</Checkout_Seq_No>
<Company_ID>123456</Company_ID>
<ShipTo_CompanyName>IPC Web Based Solutions</ShipTo_CompanyName>
<ShipTo_ContactName>Director of Technology Transfer</ShipTo_ContactName>
<ShipTo_ContactPhone>847-597-2839</ShipTo_ContactPhone>
<ShipTo_ContactEmail>kimsterling (AT) ipc (DOT) org</ShipTo_ContactEmail>
<ShipTo_Address1>3000 Lakeside Drive</ShipTo_Address1>
<ShipTo_Address2>Suite 309-S</ShipTo_Address2>
<ShipTo_City>Bannockburn</ShipTo_City>
<ShipTo_StateProvince>IL</ShipTo_StateProvince>
<ShipTo_ZipCode>60015</ShipTo_ZipCode>
<ShipTo_Country></ShipTo_Country>
<Checkout_Quantity>10</Checkout_Quantity>
<Checkout_Charge>0.0000</Checkout_Charge>
<Checkout_Status>0</Checkout_Status>
<Checkout_TimeStamp>2006-04-03T22:30:57.730</Checkout_TimeStamp>
<Shipment_Method>Standard</Shipment_Method>
<Customize_Company_Name>test 2</Customize_Company_Name>
<Customize_Text>test 2</Customize_Text>
<Customize_TimeStamp>2006-04-03T22:35:57.343</Customize_TimeStamp>
</row> |