var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calling sp from DTS on different server
Is it possibe to call a Stored Proc on a remote server in a DTS package?
Thanks in advance,
Yes, in more than one way. RPC calls via linked servers, additional connections, OpenQuery(), etc.
Will any of these work with servers that are not linked?
Originally Posted by Pat Phelan
The additional DTS connection will work nicely, whether the servers are linked or not.