Post reply

Enumerate Packages.

  • April 25, 2007 at 7:18 am

    #173739

    Hi All,

    We have a number of Packages stored in SQL Server (Local Packages). I need to enumerate all packages and then with each package I will use LoadFromSQLServer to obtain details of each package. However, I'm stuck at the first hurdle as I have no idea how to enumerate the local packages to obtain the package names.

    Thanks

  • April 25, 2007 at 8:19 am

    #702388

    You can get a list of the local packages by querying tables within the MSDB database.

    SELECT * FROM msdb.dbo.sysdtspackages

    There are other tables in the MSDB database to do with DTS information also:

    sysdtscategories

    sysdtspackagelog

    sysdtssteplog

    sysdtstasklog

    Is this the start you were after..?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • April 25, 2007 at 8:27 am

    #702392

    Thanks yes, I found some code on MSDN that was taking me down creating a Repository Object and using that, but I was having problems with the connection. I have just tries your way and I get the info I was after.

  • April 25, 2007 at 8:37 am

    #702395

    Have you got the MSDN link please? I think it'll be quite interesting to see what they're doing.

    Thanks!


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

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

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