Post reply

SSIS and EXEC sp_makewebtask

  • October 10, 2013 at 12:16 pm

    #278847

    I have an SSIS package which extracts N number of text extracts for each distinct value in col1.The package is already running fine.I would like to add some formatting and extract data into formatted HTML files.How do I do this using EXEC sp_makewebtask.

    EXEC sp_makewebtask @outputfile=C:\test.htm , @query ='select * from surgeons where col1=?'

    is not working .How do I make this work.

  • October 11, 2013 at 12:51 am

    #1657803

    http://technet.microsoft.com/en-us/library/ms180099(v=sql.90).aspx

    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.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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