Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS and EXEC sp_makewebtask Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 12:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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.
Post #1503729
Posted Friday, October 11, 2013 12:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 883, Visits: 2,807
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

@SeanPearceSQL

About Me
Post #1503888
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse