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 Please help.Troy
May 26th, 2010 7:31am

You may it useful to view this view, LINQ to XML - Streaming In Large Documents. Simon Sabin discusses this approach in SSIS. See this blog post: 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