Post reply

Is it possible to query a package from SQL to get table list

  • December 17, 2009 at 12:19 pm

    #385968

    I believe I already no the answer to this but I will ask anyway.

    Is it possible to use a query on a SSIS package that is stored in the MSDB to get all the tables it accesses. Similar to the way you can query sysobject to get the table names from a stored procedure.

    Thank you

    Lee

  • December 19, 2009 at 8:12 am

    #1094443

    Oblivisci (12/17/2009)

    I believe I already no the answer to this but I will ask anyway.

    Is it possible to use a query on a SSIS package that is stored in the MSDB to get all the tables it accesses. Similar to the way you can query sysobject to get the table names from a stored procedure.

    Thank you

    Lee

    There is no such query.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 21, 2009 at 5:27 am

    #1094681

    Thats what I thought, but thank you for verifying it.

    Lee

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

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