• Did what you suggested...still throws an error...

    Here is the code I tried executing...

    ALTER PROCEDURE [dbo].[usp_Names]

    (@ID int)

    AS

    DECLARE @TaskOutFile VARCHAR(255)

    DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

    Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

    EXEC sp_makewebtask @outputfile =@TaskOutFile , @query = @sqlquery;

    Msg 139, Level 15, State 1, Procedure usp_SurgeonProcedures, Line 0

    Cannot assign a default value to a local variable.

    Msg 137, Level 15, State 2, Procedure usp_SurgeonProcedures, Line 10

    Must declare the scalar variable "@SQLQuery".