Post reply

How to check how many packages are in the instance of sql server?

  • August 2, 2007 at 10:36 am

    #118025

    Is there any way to check how many packages have been deployed to a sql server?

    I've got 2 sql servers on the same box. i deployed a few packages to a named instance.

    When i open integration services i don't see any packages.

    Thank you

    Alex S

  • August 2, 2007 at 11:41 am

    #724276

    If they're depoyed to msdb rather than filesystem, I don't think that they will show up under integrations services (I may be wrong).  You can query msdb, though:

    select name

    from sysdtspackages90

    That should give you a list of the SSIS packages that have been deployed to msdb.

    Thanks,

    Lori

  • August 6, 2007 at 9:35 am

    #724885

    Thanks Lori

    I've got 5 packages deployed to MSDB of a named instance.

    I was able to delete packages from a named instance using

    sp_dts_deletepackage

    There is also a way to connect integration services to a named instance.

    http://www.sqlis.com/57.aspx

     

    Alex S

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

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