SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 xml file to table using ssis 2008		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nord
Yak Posting Veteran

66 Posts
Posted - 02/13/2013 :  14:02:26  Show Profile  Reply with Quote
Hi,
I have ssis xml file to sql table in xml type of column dt_ui2 ,type in sql tablq nvarchar(25)
I have error:
[XML Source [1]] Error: The "component "XML Source" (1)" failed because error code 0xC02090F8 occurred, and the error row disposition on "output column "ReferenceID" (2429)" at "output "Header" (263)" specifies failure on error. An error occurred on the specified object of the specified component.
I add derived column :
(DT_WSTR,25)ReferenceID
What i can do else?
Thanks

James K
Flowing Fount of Yak Knowledge

1488 Posts
Posted - 02/13/2013 :  14:30:51  Show Profile  Reply with Quote
Is your XML only 25 characters long? In most cases, even small XML fragments are longer than that.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47040 Posts
Posted - 02/13/2013 :  14:35:51  Show Profile  Reply with Quote
are you trying insert data from xml node to table? how is structure of xml?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

nord
Yak Posting Veteran

66 Posts
Posted - 02/13/2013 :  14:46:52  Show Profile  Reply with Quote
<?xml version="1.0" encoding="UTF-8" ?>
- <OrderImportFile xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <Header ReferenceID="457431">
<ShipTo>15432</ShipTo>
<ShipToAddress1>1375 Tyne</ShipToAddress1>
<ShipToAddress2 />
<ShipToCity>Longueuil</ShipToCity>
<ShipToCountry>Canada</ShipToCountry>
<ShipToName>Patrick Desroches</ShipToName>
<ShipToPostalCode>J4J4R6</ShipToPostalCode>
<ShipToState>Quebec</ShipToState>
<OrderDate>20130211</OrderDate>
</Header>
- <Item ReferenceID="457431">
<OrderLineNumber>1</OrderLineNumber>
<Item>ARCHI01</Item>
<ItemDescription>Archi lamp (165 cm x 203 cm)</ItemDescription>
<QuantityUnitofMeasure>EA</QuantityUnitofMeasure>
<TotalQuantity>1</TotalQuantity>
</Item>
</OrderImportFile>
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47040 Posts
Posted - 02/13/2013 :  23:33:25  Show Profile  Reply with Quote
whats the datatype of ReferenceID in output metadata in ssis?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

nord
Yak Posting Veteran

66 Posts
Posted - 02/14/2013 :  09:33:15  Show Profile  Reply with Quote
I found,changed type to dt_iu4,thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47040 Posts
Posted - 02/14/2013 :  09:50:46  Show Profile  Reply with Quote
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000