Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

imoprt XML Data from xml file having more than 15000 charecter row to sql server destination using ssis Expand / Collapse
Author
Message
Posted Thursday, October 4, 2012 10:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 1, 2013 8:24 PM
Points: 17, Visits: 127
In my Xml file one column having more than 15000 thousand charecter row, but in xml source read only 4000 charecter row, how can i resolve the problem.

Having any idea please help me:







Post #1368565
Posted Sunday, October 7, 2012 3:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:51 PM
Points: 1,117, Visits: 2,220
Try changing the column type to DT_NTEXT.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #1369578
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse