Post reply

Loop through Packages in SQL Server

  • July 12, 2007 at 2:53 pm

    #69848

    I need to look into how I could loop through all DTS packages in my SQL Server and rename the ServerName property. Any tips are greatly appreciated.

    -W R

  • July 13, 2007 at 2:20 am

    #719208

    Hi,

    I'm not sure what you mean by ServerName property. Are you looking at the Package Log Server or is this a SQL Server connection object in each package, or something different?

    If it's a SQL Server connection object in each package then there's not much you can do. The DTS package details are stored in the msdb.dbo.sysdtdpackages table but the information is encoded (Microsoft proprietary).

     


    Ade

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

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

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