Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Change the ownership of a DTS Package

Author  Topic 

sp_wiz
Yak Posting Veteran

55 Posts

Posted - 2001-08-28 : 10:14:40
I'm having a major issue trying to change the ownership of a dts package

The senario is I have a Hosted SQL server and when ever i connect to it at create a package it saves the owner as my local sql server. Which is a real pain as i need dbo to own it so i can call it from a web page.

I've read about sp_reassignDTSpackage, but that does not seem to work. It asks for a uniqueidentifier. Where is that generated.

Cheers
robp


   

- Advertisement -