Post reply

Output to Text File Using SSMS Maint Plan

  • July 13, 2009 at 1:28 pm

    #202244

    Hi Folks

    I am wonder if there is anyway to get the output from the T-SQL you put into a "Execute T-SQL Statement Task" in a Maint plan or is that NOT do-able ?

    Thanks

    Jim

  • July 13, 2009 at 6:16 pm

    #1024197

    You might try adding output to a file in the job that calls the maintenance plan (since it is really just an SSIS package)..

    CEWII

  • July 14, 2009 at 3:53 pm

    #1024750

    Hi Elliot

    i will try that as soon as i figure out how to do it

    Thanks

    jim

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

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