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: Friday, October 10, 2014 4:30 AM
Points: 18, Visits: 132
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: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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