Has anyone successfully replaced sp_makewebtask? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Has anyone successfully replaced sp_makewebtask?

Author

Topic

shaunos
Starting Member

8 Posts

Posted - 2011-04-26 : 07:28:25

Hi,

We are currently migrating our systems from sqlserver 2000 to sqlserver 2008R2 and have run into the makewebtask stumbling block. (Dear God have I cursed Micro$oft from on high for removing a simple to use feature like sp_makewebtask and forcing us to use a bulky PITA that is SSIS!!)

Anyway, has anyone managed to get around this 'enhancement' in an easy manner? Is it possible to create a dynamic SSIS report that takes a query and output file as variables in the manner that makewebtask did?

Or is there an easier way to dump the contents of a query to an excel file that I haven't google'd across yet?

At a glance it looks like we use this approx 80 times across our systems so I don't fancy having to sit down and create 80 frickin projects and calling them from stored procedures...

Any help gratefully appreciated..

~Shaun
(Rapidly becoming folically challenged!)

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-26 : 08:07:32

Yeah, once Microsoft got the XML religion they abandoned all that HTML nonsense.

Any reason you can't use Reporting Services? They can export to Excel (yeah, I know) and HTML and is really the proper platform for doing reports.

sqldba20
Posting Yak Master

183 Posts

Posted - 2011-04-26 : 09:36:30

I don't know about 2008R2 but when we had migrated from SQL 2000 to 2005 as a temporary workaround we had manually created a stored procedure sp_insmswebtask . The best solution is to use SQL Reporting services.

CREATE PROCEDURE sp_insmswebtask
-- This procedure is for internal use by Web Assistant
    @procname		nvarchar(128),
    @outputfile		nvarchar(255),
    @taskstat		bit,
    @wparams		image,
    @trigflags		smallint,
    @taskid			int
AS
    INSERT INTO  dbo.mswebtasks(procname, outputfile, taskstat, wparams, trigflags, taskid)
	    VALUES(@procname, @outputfile, @taskstat, @wparams, @trigflags, @taskid)

shaunos
Starting Member

8 Posts

Posted - 2011-04-26 : 09:52:04

Thanks, I think the makewebtask stuff still worked in 2005 but has been completely deprecated for 2008... sigh...

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-26 : 10:24:24

Have you tried copying the code from 2005 and creating it on your 2008 instance?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources