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
Posted Thursday, October 10, 2013 12:16 PM


Group: General Forum Members
Last Login: 2 days ago @ 2:48 AM
Points: 195, Visits: 692
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

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:26 AM
Points: 1,066, Visits: 3,191

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


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

Add to briefcase

Permissions Expand / Collapse