Name of server where package is stored

  • marykdba

    Mr or Mrs. 500

    Points: 574

    Is it possible for a SSIS package to retrieve the name of the server where it is stored?

  • andrew gothard


    Points: 12297

    There's the System::MachineName variable - I always tend to use this in environments where the environment is less "controlled" and the package may be moved at short notice.

    Well - actually - I'm a bit obsessive. I always use it, just in case. I'm like that.

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

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

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