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 |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2013-02-13 : 14:02:26
|
| 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)ReferenceIDWhat i can do else?Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-13 : 14:30:51
|
| Is your XML only 25 characters long? In most cases, even small XML fragments are longer than that. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-13 : 14:35:51
|
| are you trying insert data from xml node to table? how is structure of xml?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-02-13 : 14:46:52
|
| <?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> |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-13 : 23:33:25
|
| whats the datatype of ReferenceID in output metadata in ssis?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-02-14 : 09:33:15
|
| I found,changed type to dt_iu4,thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-14 : 09:50:46
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
xml file to table using ssis 2008