dbTalk Databases Forums  

SSIS - XML Data Type (Column)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS - XML Data Type (Column) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry
 
Posts: n/a

Default 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>


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.