Modify DTS from local desktop | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Modify DTS from local desktop

Whenever I want to modify my DTS package, I change it on the server box itself. The question is that is it possible to do it remotely without any impact on the DTS (i.e. the owner will be changed if I modify it from my desktop).
CanadaDBA
To change the owner of the DTS package you can perform it from the QA (your desktop)using this undocumented SP http://www.databasejournal.com/features/mssql/article.php/1461511]. KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;247052 for information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>