Post reply

sp_makewebtask or BCP toexport XML file...

  • December 16, 2008 at 9:52 pm

    #129325

    I found two option to export XML file from large table.

    1. sp_makewebtask

    2. BCP Command.

    Can anyone suggest to choose one from both?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • December 17, 2008 at 12:48 am

    #913640

    For the ease of managing I would suggest SP_MAKEWEBTASK - http://sqlxml.org/faqs.aspx?faq=29 fyi

    -Satya SK Jayanty
    SQL Server MVP (Follow me @sqlmaster)
    Author of SQL Server 2008 R2 Administration CookBook
    SQL Server Knowledge Sharing network

  • December 17, 2008 at 12:16 pm

    #914093

    Excerpt from BO:

    sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server 2005 Reporting Services (SSRS).

    This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

    MJ

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

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