Problems exporting large XML to Flat file destination (seems to be truncated somewhere)
I have a datatask In it I have an OledbSource with an sql statement like "SELECT lotsoflines from bigtable for xml auto" And I have this going to a flat file destination. It works fine for small files but large files (>1.39MB) seem to be truncated. I got this approach from http://blogs.msdn.com/b/jenss/archive/2009/11/06/an-secret-ssis-xml-destination-provider-you-might-not-found-yet.aspx Please help.Troy
May 26th, 2010 7:31am

You may it useful to view this view, LINQ to XML - Streaming In Large Documents. http://www.microsoft.com/uk/msdn/screencasts/screencast/289/LINQ-to-XML-Streaming-In-Large-Documents.aspx Simon Sabin discusses this approach in SSIS. See this blog post: http://www.microsoft.com/uk/msdn/screencasts/screencast/289/LINQ-to-XML-Streaming-In-Large-Documents.aspx Carla Sabotta
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 5:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics