Post reply

Manual ssrs subscriptions - jason selburgs guide

  • December 8, 2015 at 7:37 am

    #313739

    hi

    i am trying to follow the below article

    http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/#StoredProc

    which looks exactly what i require for sql 2005 std, as i need to pass a parameter to a report and email to the appropriate people.

    but when i execute the sp, i get the below error, which i have no clue on how to fix,any one any ideas for me?

    mal

    Job 'DD1C75F3-2CD5-43A7-97B5-C01DAB758EEB' started successfully.

    Msg 7135, Level 16, State 2, Procedure data_driven_subscription, Line 204

    Deletion length 2 is not in the range of available text, ntext, or image data.

    The statement has been terminated.

  • December 8, 2015 at 7:39 am

    #1844654

    what i pass to the sp

    exec data_driven_subscription

    @scheduleID ='DD1C75F3-2CD5-43A7-97B5-C01DAB758EEB',

    @emailTO = 'm22222@zzzzzzzz.com',

    @emailCC = 'm22222@zzzzzzzz.com',

    @emailBCC = 'm22222@zzzzzzzz.com',

    @emailReplyTO = 'm22222@zzzzzzzz.com',

    @emailBODY = 'hello ',

    @param1 = '25'

  • December 8, 2015 at 8:25 am

    #1844667

    Double check your base subscription in the UI. You must have missed something syntactically. If I remember correctly, these errors were usually caused by typos but regardless, they almost ALWAYS require you to delete the base job and recreate it.

    Try adding some print statements here and there to help debug.

    that's about all I can think of after 9 years. 😛

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • December 8, 2015 at 9:16 am

    #1844698

    no probs Jason, i was being optimistic!

    have double checked, and everything matches up, ill just have to do a bit more playing about with it !

    thanks

    mal

  • December 8, 2015 at 9:24 am

    #1844701

    actually i did make a mistake 🙂

    i had assigned the parameter in the report as @param instead of using |P1|

    now works a treat jason , brilliant article!

    thanks

    mal

Viewing 5 posts - 1 through 4 (of 4 total)

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