Knowing what server a DTS package is opened from

Question

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

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

Steve Jones - SSC Editor SSC Guru Points: 739010 More actions · Answer 1

There are a few tricks. One is to set the package to connect to (local), which will be the default instance.

another is to use the Dynamic Properties task to query @@server, but you need a connection for that.

You could also use a global variable, but you'd have to set this.

If you don't use instances, I'd use (local), otherwise, there isn't a way.

Steve Jones