Post reply

how to check if agentjob is executing on a sql 2000 server using ssis

  • October 28, 2009 at 4:34 am

    #134715

    i have two servers 1 with sql 2005 server and one with sql 2000 server now i need to use SSIS to check if a job is executing on the sql 2000 server. how do i do that?

    Don´t know where i can get that information from the SQL 2000 server. i try using this

    exec sp_get_composite_job_info @execution_status = 1

    in my OLE DB Source

    but with that i get hits in the preview but when i try to run the ssis package ill get this error

    "Package Validation Error

    Error at Data Flow Task[DTS:Pipeline]: "output"OLE DB Source Output"(11)" contains no output columns. an asynchronous output must contain output columns........."

    How do i solve that using that stored procedure?

    Thx for all the help

  • October 28, 2009 at 8:54 am

    #1071808

    Hi - I *think* your problem comes down to the fact that SSIS cannot tell what columns will come back from a Stored Procedure. A different set of columns could come back each time you run a SPROC.

    You could try using

    SET FMTONLY OFF

    before you call your SPROC - this has helped me in the past.

    Ideally though you need a stright query to return the running jobs rather than a SPROC.

    Hope this is useful.

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

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