Need to change the owner of database package

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

Chris_P SSCommitted Points: 1753 More actions · Answer 1

Hi,

Can you provide specifics? I'm not sure what you mean by "database package."

Are you trying to change the owner of a Database, a DTS or SSIS package or a schema?

Chris.

bubby SSCertifiable Points: 5638 More actions · Answer 2

SSCertifiable

Points: 5638

October 7, 2008 at 12:38 pm

Sorry it DTS Package

Chris_P SSCommitted Points: 1753 More actions · Answer 3

Thats better. 🙂

Out of curiosity, why do you want to change the owner of the package? As far as I know this doesn't actually mean anything.

Chris.

bubby SSCertifiable Points: 5638 More actions · Answer 4

Hello Chris,

The job associated is failing, the DTS package is under user name with read privelages, I wanted to change that,

Please Advice,

Thanks,

Dev

Chris_P SSCommitted Points: 1753 More actions · Answer 5

Ok, thats what I suspected. The owner of the DTS package isn't important in this case, its the job owner that is.

From Enterprise Manager open Management | SQL Server Agent | Jobs and navigate to your job. Double click on it and change the owner here.

Chris.

nary SSCrazy Points: 2869 More actions · Answer 6

Anyway if you want to still change the owner of DTS package then use undocumented SP in MSDB to do it (sp_reassign_dtspackageowner [@name =] 'name',

[@id =] 'id',

[@newloginname =] 'newloginname'