Post reply

export large XML file

  • December 8, 2009 at 11:03 am

    #228405

    hi,

    I have a big table 800K records that I need to export into an XML file using SSIS. Is there a good way to achieve this?

  • December 8, 2009 at 12:43 pm

    #1089440

    What have you tried so far? What problems are you having? What problems are you envisaging?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 8, 2009 at 3:18 pm

    #1089562

    saibhushan musalappa (12/8/2009)

    hi,

    I have a big table 800K records that I need to export into an XML file using SSIS. Is there a good way to achieve this?

    If you can use third-party solutions, check the commercial CozyRoc Template Task. You can generate arbitrary text with it. First you construct a text template for the exported format and then you can connect your template to different parameters like variables, files or data flows. The process is very similar to the creation of ASP or JSP page. Also you can export unlimited amount of text with it because the data is streamed.

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply