web page generation task

  • Hi all,

    After running the following task I get an error (Server: Msg 8114, Level 16, State 4, Procedure sp_makewebtask, Line 0

    Error converting data type nvarchar to tinyint.)

    Any Ideas?

    USE MyDB

    EXEC sp_makewebtask

      @outputfile='c:\InetPub\WWWRoot\aa\title.html',

      @query='SELECT *

              FROM Titles',

      @HTMLHeader=1,

      @webpagetitle='Title Page',

      @resultstitle= 'Title Page',

      @whentype=8,

      @numunits=l,

      @unittype=2,

      @procname=web_CreateTitlePage

     

  • You have an L in @numunits instead of a 1.



    Shamless self promotion - read my blog http://sirsql.net

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

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